Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if statement
sI am trying to determine how many times a date may occur each month. In
other words I might have 5 meeting between 1/1/09 and 1/31/09 and 10 meeting the next month. How do I track the number of time a meeting might occur each month? What is the formula-is it a count if statement? Thanks, Frank |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if statement
I assume you want to count dates for a specific month and year.
One way... =SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2009)) That will count all dates in January 2009. Just change the month and/or year number as needed. -- Biff Microsoft Excel MVP "frankb" wrote in message ... sI am trying to determine how many times a date may occur each month. In other words I might have 5 meeting between 1/1/09 and 1/31/09 and 10 meeting the next month. How do I track the number of time a meeting might occur each month? What is the formula-is it a count if statement? Thanks, Frank |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if statement
Hi,
Without your data layout we generally would use =COUNTIF(Range,Criteria) or =SUMPRODUCT(--(A1:A100=--"1/1/09"),--(A1:A100<=--"1/31/09")) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "frankb" wrote: sI am trying to determine how many times a date may occur each month. In other words I might have 5 meeting between 1/1/09 and 1/31/09 and 10 meeting the next month. How do I track the number of time a meeting might occur each month? What is the formula-is it a count if statement? Thanks, Frank |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if statement
Thank you Shane! that worked perfectly!
Frank "Shane Devenshire" wrote: Hi, Without your data layout we generally would use =COUNTIF(Range,Criteria) or =SUMPRODUCT(--(A1:A100=--"1/1/09"),--(A1:A100<=--"1/31/09")) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "frankb" wrote: sI am trying to determine how many times a date may occur each month. In other words I might have 5 meeting between 1/1/09 and 1/31/09 and 10 meeting the next month. How do I track the number of time a meeting might occur each month? What is the formula-is it a count if statement? Thanks, Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If & Count Statement | Excel Worksheet Functions | |||
better way to write a count if statement? | Excel Worksheet Functions | |||
Count If Statement Using Dates | Excel Discussion (Misc queries) | |||
Help with Count IF Statement | Excel Discussion (Misc queries) | |||
count if statement | Excel Discussion (Misc queries) |