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