Another one:
=SUMPRODUCT(--(TEXT(F2:S233,"yyyymm")="200901"))

This will calculate slower than Per's suggestion--especially if the range gets
larger, but it's easier to type <vbg.





wally wrote:

In a spreadsheet I have dates and times of events (example 10/2/2009 03:12)
in cells F2:S233. I need to count the events by month, ie January had 'x'
number of events, February had 'x' number of events, and so on. For my need,
the time is irrelevant. Your suggestion would be appreciated. Thanks.

--

Dave Peterson