thank you, it's returning a "#VALUE!"
the date is in "date" format. will that still equate March to "3"?


"Elkar" wrote:

Try this:

=SUMPRODUCT(--(A1:A100="Joe"),--(MONTH(B1:B100)=3),--(C1:C100="yes"))

HTH
Elkar


"ccKennedy" wrote:

hello,
i need to count the number of times each of 5 reps made an entry in March.
the entry date is full date format (3-Mar-09) & the countif function isn't
workng.
example:
Rep Date Appt
Joe 3-mar-09 yes
Mary 5-mar-09 yes
etc

so, need to know how many times Joe made an entry in March, and need to know
how many appts were "yes" or made.