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

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.

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

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.

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

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" wrote in message
...
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.

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

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.

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

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


"Fred Smith" wrote:

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" wrote in message
...
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.

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

Hi,

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ccKennedy" wrote in message
...
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.

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

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

Regards,
Fred.

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


"Fred Smith" wrote:

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" wrote in message
...
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.