counting a cell range within a range
 

i want to count how many cells within the range determined in the
following formula also have the value "x" in the range D2:D3000:

=SUMPRODUCT(--(MONTH(log!$A$2:$A$3000)=7),--(YEAR(log!$A$2:$A$3000)=2005))

i then want to subtract that number from the number determined by the
previous formula.

thanks!


--
mmay321
------------------------------------------------------------------------
mmay321's Profile: http://www.excelforum.com/member.php...o&userid=25492
View this thread: http://www.excelforum.com/showthread...hreadid=394364

You just add in another condition to SUMPRODUCT:

=SUMPRODUCT(--(MONTH(log!$A$2:$A$3000)=7),--(YEAR(log!$A$2:$A$3000)=2005),--($D$2:$D$3000="x"))

I assume you can get the rest.


--
David Billigmeier


"mmay321" wrote:


i want to count how many cells within the range determined in the
following formula also have the value "x" in the range D2:D3000:

=SUMPRODUCT(--(MONTH(log!$A$2:$A$3000)=7),--(YEAR(log!$A$2:$A$3000)=2005))

i then want to subtract that number from the number determined by the
previous formula.

thanks!


--
mmay321
------------------------------------------------------------------------
mmay321's Profile: http://www.excelforum.com/member.php...o&userid=25492
View this thread: http://www.excelforum.com/showthread...hreadid=394364

i entered the formula:

=SUMPRODUCT(--(MONTH(log!$A$2:$A$3000)=7),--(YEAR(log!$A$2:$A$3000)=2005),--($D$2:$D$3000="x"))

and it yields the following:
1/0/1900 0:00


i don't know what that means!


--
mmay321
------------------------------------------------------------------------
mmay321's Profile: http://www.excelforum.com/member.php...o&userid=25492
View this thread: http://www.excelforum.com/showthread...hreadid=394364