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
|