Don't discount the sum functions for counting

=SUMPRODUCT(--(MONTH(A1:A5)=2))

will count all of the dates in A1:A5 that are February (ie equal to 2).

You could also use the regular sum function, but it would have to comitted
w/Control+Shift+Enter

=SUM(--(MONTH(A1:A5)=2))



"Zerosumgame" wrote:

I have a multi-page worksheet, sorted out by date and type of work done. I am
looking for a reasonable way to COUNT all the entries in certain months.
Every function i try errors out. And combining MONTH with COUNTIF does not
seem to work. i do not want to SUM them, just to COUNT them.