Condition formulas for multiple columns

  • Thread starter Thread starter Rudy
  • Start date Start date
R

Rudy

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!
 
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
 
=SUMIF(C3:P32,"HBA",D3:D32,H3:H32,J3:J32,L3:L32,N3: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.
 
Back
Top