Hi Kim
Try
=SUMPRODUCT(--(TEXT(SheetName!J5:J8,"mmmm")="January")*(SheetName!J5:J8,<>))
--
Regards
Roger Govier
"Kim" <[email protected]> wrote in message
news:[email protected]...
>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.
Bookmarks