SUMPRODUCT

[Connie Martin]

I posted a question last week, to which I received the answer I needed, and
now I'm trying to apply the same style of formula to another already existing
formula but it isn't working and I can't figure it out. I have these
existing formulas:

=IF(COUNT(L30:L500)=0,"",COUNTIF(L30:L500,">0"))
=IF(COUNT(L30:L500)=0,"",COUNTIF(L30:L500,"<-4"))

With both of these formulas I want to count only if "BAG" is in E30:E500.

Thank you
Connie

 

[Arvi Laanemets]

Hi

=IF(COUNT(L30:L500)=0,"",SUMPRODUCT(--(L30:L500>0),--(E30:E500="BAG")))

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


Arvi Laanemets

 

[Connie Martin]

This appears to work. Thank you very much!

Hi

=IF(COUNT(L30:L500)=0,"",SUMPRODUCT(--(L30:L500>0),--(E30:E500="BAG")))

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


Arvi Laanemets