Hi Farrel,

Try this:

=SUMPRODUCT((A1:A10="Joe")*(MONTH(B1:B10)=5)*(YEAR (B1:B10)=2005))

Regards,
KL


"Farrel" wrote in message
...
I'm trying to count how many times a specific name appears on a date range
I have column "A" with Names and column "B" with Dates
For example I want to know how many "Joe" I have on May/05
Txs