software

I am trying to set up a formula that will count the instances of specific
dates. Example: Only count the number of times that a cell in Column B
(B4=1) and a corresponding cell in Column C (C4=2) meet the required
parameters.

I have been trying to use the COUNTIF function but can not get it to work
with the AND function since the AND function does not seem to work well with
a range of data.

Any help would be appreciated.

Try this:
A1: (some value)
A2: (some other value)
A3: =SUMPRODUCT(--(B1:B10=A1),--(C1:C10=A2))

Counts the combinations of Col_A=A1 and Col_B=A2.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;Billquot; wrote:

gt; I am trying to set up a formula that will count the instances of specific
gt; dates. Example: Only count the number of times that a cell in Column B
gt; (B4=1) and a corresponding cell in Column C (C4=2) meet the required
gt; parameters.
gt;
gt; I have been trying to use the COUNTIF function but can not get it to work
gt; with the AND function since the AND function does not seem to work well with
gt; a range of data.
gt;
gt; Any help would be appreciated.


Bill,

Try this.

=SUMPRODUCT(--(ISNUMBER(FIND(DATE(2005,12,22),B1:B10))),--(C1:C10=DATE(2005,12,25)))

Just change the dates in the DATE function to whatever dates you are
looking for.Cheers,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=495488
Ron's is definitely a simpler version. I just started experimenting
with SUMPRODUCT so thanks Ron. I have seen this used many times on
this site but don't fully understand what the -- that preceeds the
conditions do. I've searched on the Help files with no luck. Any
quick way to explain? Is there a site that you could suggest?

Thanks,Happy Holidays.Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=495488www.xldynamic.com/source/xld.SUMPRODUCT.html--

Regards,

Peo Sjoblom

quot;SteveGquot; gt; wrote in
message ...
gt;
gt; Ron's is definitely a simpler version. I just started experimenting
gt; with SUMPRODUCT so thanks Ron. I have seen this used many times on
gt; this site but don't fully understand what the -- that preceeds the
gt; conditions do. I've searched on the Help files with no luck. Any
gt; quick way to explain? Is there a site that you could suggest?
gt;
gt; Thanks,
gt;
gt;
gt; Happy Holidays.
gt;
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile:
www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=495488
gt;

Thanks for the link!--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=495488