SUMPRODUCT
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
|