Sorry ... my typo ....

=SUMPRODUCT(--(A1:A27="BOB"),--(MONTH(B1:B27)=5),--(YEAR(B1:B27)=2007))


"MDI Anne" wrote:

This first formula (for month only) works fine...but the second one (for
month & year) comes up with zeros only. What am I doing wrong? I copied
directly from here to my worksheet....

"Toppers" wrote:

this will count of BOB for MAY (month 5)

=SUMPRODUCT(--(A1:A27="BOB"),--(MONTH(B1:B27)=5))

For a specific month/year

=SUMPRODUCT(--(A1:A27="BOB"),--(MONTH(B1:B27)=5),--YEAR(B1:B27)=2007))


You can replace "BOB" with cell containing the text "BOB"

HTH

"MDI Anne" wrote:

I have 2 columns of data: one is name, the other is dates.

BOB 5/1/2007
STEVE 4/19/2007
JOHN 3/22/2007
MARY 7/21/2006
KATHY 5/4/2007
BOB 10/7/2006
STEVE 5/22/2007
MARY 5/14/2007
MARY 3/7/2007
MARY 5/30/2007
KATHY 1/5/2007
JOHN 5/15/2007
BOB 5/25/2007
STEVE 5/13/2007
BOB 5/1/2007
STEVE 4/19/2007
JOHN 3/22/2007
MARY 7/21/2006
KATHY 5/4/2007
BOB 10/7/2006
STEVE 5/22/2007
MARY 5/14/2007
MARY 5/30/2007
KATHY 1/5/2007
JOHN 5/15/2007
BOB 5/25/2007
STEVE 5/13/2007


I'd like to know how many times each name shows up in the month of May (or
whatever month I'm looking for). So, if I need a "findbetween" or some other
formula, I would love some help.

Thanks all, in advance!