=SUMPRODUCT(--(A2:A100="Joe"),--(B2:B100=--"2005-005-05"))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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
|