Condition formulas for multiple columns
I am trying to create a sum if formula for multiple columns that cross over
each other where the criteria is in the first column and the values are in the 2nd columns. There are 7 colums for each and they overlap. Here is the formula I have been trying to use, but I think there are too many ranges. =SUMIF(C3:P32,"HBA",D3:D32,H3:H32,J3:J32,L3:L32,N3 :N32,P3:P32) 1 HBA 100 HBA 100 2 TLE 50 TLE 50 3 STA 25 STA 25 4 PAP 50 PAP 50 5 HBA 100 HBA 100 Thanks! |
Condition formulas for multiple columns
Hi,
Try this =SUMPRODUCT(($C$3:$C$32=$C40)*(MOD(COLUMN($H$3:$P$ 3),2)=0)*($H$3:$P$32))+SUMIF($C$3:$C$32,$C40,$D$3: $D$32) C40 has HBA -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Rudy" wrote in message ... I am trying to create a sum if formula for multiple columns that cross over each other where the criteria is in the first column and the values are in the 2nd columns. There are 7 colums for each and they overlap. Here is the formula I have been trying to use, but I think there are too many ranges. =SUMIF(C3:P32,"HBA",D3:D32,H3:H32,J3:J32,L3:L32,N3 :N32,P3:P32) 1 HBA 100 HBA 100 2 TLE 50 TLE 50 3 STA 25 STA 25 4 PAP 50 PAP 50 5 HBA 100 HBA 100 Thanks! |
Condition formulas for multiple columns
=SUMIF(C3:P32,"HBA",D3:D32,H3:H32,J3:J32,L3:L32,N 3:N32,P3:P32)
Are you missing the range F3:F32 is the sum_range? Try this... =SUMIF(C3:O32,"HBA",D3:P32) Note how the range arguments are offset. -- Biff Microsoft Excel MVP "Rudy" wrote in message ... I am trying to create a sum if formula for multiple columns that cross over each other where the criteria is in the first column and the values are in the 2nd columns. There are 7 colums for each and they overlap. Here is the formula I have been trying to use, but I think there are too many ranges. =SUMIF(C3:P32,"HBA",D3:D32,H3:H32,J3:J32,L3:L32,N3 :N32,P3:P32) 1 HBA 100 HBA 100 2 TLE 50 TLE 50 3 STA 25 STA 25 4 PAP 50 PAP 50 5 HBA 100 HBA 100 Thanks! |
All times are GMT +1. The time now is 05:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com