Condition formulas for multiple columns

[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(C332,"HBA",D332,H3:H32,J3:J32,L3:L32,N3:N32,P332)
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!

 

[Ashish Mathur]

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

 

[T. Valko]

=SUMIF(C332,"HBA",D332,H3:H32,J3:J32,L3:L32,N3:N32,P332)

Are you missing the range F3:F32 is the sum_range?

Try this...

=SUMIF(C3:O32,"HBA",D332)

Note how the range arguments are offset.