count month when date is in day/month/year format

[ccKennedy]

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.

 

[Elkar]

Try this:

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

HTH
Elkar

 

[Fred Smith]

What formula did you use? Countif will do what when used properly.

When you post back, be sure to identify whether you have a true Excel date,
or whether it's text.

Regards,
Fred.

 

[ccKennedy]

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

 

[ccKennedy]

tried countif and tried sumproduct - it's not reading the date, which is in
date format in excel, properly...

 

[Ashish Mathur]

Hi,

Use the ISNUMBER() function on the date column. Do they evaluate to TRUE

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Fred Smith]

Pretty tough to tell you what is going wrong until you post the formulas you
used.

Regards,
Fred.