How about:

=SUMPRODUCT(--(E30:E500="BAG"),--(L30:L500=-4),--(L30:L500<=0))



Connie Martin wrote:

I have this formula, which works wonderfully, but I want to expand it:
=COUNTIF(L30:L500,"=-4")-COUNTIF(L30:L500,"0")
I want that formula to count only if "BAG" is in E30:E500.

Is this possible?

Connie

--

Dave Peterson