Ragdyer Wrote:
=SUMPRODUCT((M8:M78="Metro")*(MONTH(N8:N78)=10))
Thanks so much for the quick reply. Your formula worked perfectly. I
modified it slightly to reference another worksheet but it still worked
well. Here's what I ended up with.
=SUMPRODUCT(('PRT Metrics'!M8:M78="Metro")*(MONTH('PRT
Metrics'!G8:G78)=10))
Also, thanks to Aladin Akyurek for his suggestion. I just tried your's
because it looked like a more concise solution to my problem.
--zbert
--
zbert
------------------------------------------------------------------------
zbert's Profile:
http://www.excelforum.com/member.php...o&userid=15920
View this thread:
http://www.excelforum.com/showthread...hreadid=274000