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

Hi

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

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


Arvi Laanemets


"Connie Martin" wrote in message
...
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

This appears to work. Thank you very much!

"Arvi Laanemets" wrote:

Hi

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

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


Arvi Laanemets


"Connie Martin" wrote in message
...
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