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