J
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.
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.