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