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!