Thread: SUMPRODUCT
View Single Post
  #1   Report Post  
Connie Martin
 
Posts: n/a
Default 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