Try this, with the date in Column N:
=SUMPRODUCT((M8:M78="Metro")*(MONTH(N8:N78)=10))
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"zbert" wrote in message
...
The following countif function works well for me but I was wondering how
I could use a date range criteria from a different column. I want to
count all ocurrences of "Metro" in the month of Otcober.
=COUNTIF('PRT Metrics'!M8:M78,"Metro")
This formula counts all occurences of the word "Metro" in the range
M8:M78.
I'd like to count all occurence within a given month.
--
zbert
------------------------------------------------------------------------
zbert's Profile:
http://www.excelforum.com/member.php...o&userid=15920
View this thread: http://www.excelforum.com/showthread...hreadid=274000