Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Shorten sumproduct formula | Excel Discussion (Misc queries) | |||
adding two sumproduct formulas together | Excel Worksheet Functions | |||
Sumproduct in Excel Spreadsheet to read Access db table | Excel Worksheet Functions | |||
SUMPRODUCT using offset from ROW if X marks the spot | Excel Worksheet Functions |