=SUMPRODUCT(--(TEXT(A2:A5,"mmm-yy")=TEXT(E2,"mmm-yy")))

where E2 houses a true date value with the date component set to 1 like
11/1/04.

Omega Wrote:
How do I get the COUNTIF criteria to recognize only month and year on a
range
with specific dates?


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=275710