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

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

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

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