Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
date format only showing month year | Excel Discussion (Misc queries) | |||
Format date with just month and year | Excel Discussion (Misc queries) | |||
I need date format to be set up as month/year. | New Users to Excel | |||
Month Year Date Format | Excel Worksheet Functions |