Thank you. I could not get this to work. Excel tells me my function
contains an error.

"Roger Govier" wrote:


Hi Kim

Try
=SUMPRODUCT(--(TEXT(SheetName!J5:J8,"mmmm")="January")*(SheetNam e!J5:J8,<))

--
Regards
Roger Govier
"Kim" wrote in message
...
I am trying to implement the following function to count the number of
entries I have for January, February, etc.

=SUMPRODUCT(--(TEXT(SheetName!J5:J8,"mmmm")="January"))

It works fine for February, March, etc. but not for January because it
reads
the empty cells as being 01/01/1901. Any suggestions? Thanks.