Sumif across multiple ranges

[Jarod]

I have a sumif formula situation that is killing me.

Column C, D, E, F, and G all have ranges of numbers divided into groups (5
rows to a group). I have 6 groups total. Every row after each group has a
row that adds all the numbers for that group.

A1: Name
B1: H
C1: 100
D1: $1000
E1: $2000
F1: 50
G1: $5000

I need a formula that will allow me to add columns C, D, E, F, and G based
on whether or not it has a "H" in B.

I tried:
=sumif($C5:$C52,"L",D4852,D3742,D2631,D1620,D510)

but there are too many groups, after D3742, it says I have too many.

 

[Jarod]

The formula is =sumif($C5:$C52,"H",D4852,D3742,D2631,D1620,D510), I
had accidentally used L in the example above.

 

[vezerid]

=SUMIF($B5:$B52,"L",$C5:$C52)

HTH
Kostis Vezerides

 

[Jarod]

You know, I was REALLY overthinking that formula! Thanks! I was worried it
was going to count the group totals, but forgot I wouldn't be putting H or L
in that cell!