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

"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!

=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!