You may want to add that --(SheetName!K4:K800<"") portion into your formula.

Try clearing the contents on sheetname!K4.

An empty cell will look like January when you do: =text(a1,"mmmm")

Kim wrote:

Thank you. I got it to work.
=SUMPRODUCT(--(TEXT(SheetName!K4:K800, "mmmm")="January"),
--(Countrywide!K4:K800<0))

"JE McGimpsey" wrote:

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,<))


--

Dave Peterson