That gives me an error. Perhaps something like this, instead:

=SUMPRODUCT(--(MONTH(SheetName!J5:J8)=1),--(SheetName!J5:J8<""))


Note that if you're going to do the array multiplication first, using *,
there's no reason to use the double unary minuses (--). If you're going
to let SUMPRODUCT to the array multiplication by using the comma
notation, the double unary minuses are needed. The latter is slightly
more efficient.

In article ,
"Roger Govier" wrote:

Hi Kim

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