Assuming that they are real dates

=SUMPRODUCT(--(A1:A100="Jim"),--(TEXT(B1:B100,"mmmyy")="Jan06"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jim Jackson" <Jim wrote in message
...
I have one column with names and another with date ranges (JAN06) etc. I
want to count the number of times a name occurs within a given date range.