Update SUM when new row is inserted - can I copy this formula

[bchez]

I have a formula in cell I22 =SUM(INDIRECT("I2:I"&ROW()-1)) which will update the SUM if I insert new rows. However, when I copy this formula to another column, L for example, the formula still says Column I. Any way to make the formula copy and paste friendly? Thanks!

 

[StephenCrump]

It can be done that way, but have you considered a simpler SUMIF approach with the summary at the top?

	A	B	C	D
1
2	Totals
3	EAST		15	32
4	WEST		60	36
5			75	68
6
7	District	Person	Amount 1	Amount 2
8	EAST	A	3	7
9	EAST	B	5	23
10	EAST	C	7	2
11	WEST	D	11	13
12	WEST	E	13	1
13	WEST	F	17	5
14	WEST	G	19	17
1

Cell Formulas
Range	Formula
C3:D4	C3	=SUMIF($A$8:$A$14,$A3,C$8:C$14)
C5:D5	C5	=SUM(C3:C4)

 

[bchez]

It can be done that way, but have you considered a simpler SUMIF approach with the summary at the top?

	A	B	C	D
1
2	Totals
3	EAST		15	32
4	WEST		60	36
5			75	68
6
7	District	Person	Amount 1	Amount 2
8	EAST	A	3	7
9	EAST	B	5	23
10	EAST	C	7	2
11	WEST	D	11	13
12	WEST	E	13	1
13	WEST	F	17	5
14	WEST	G	19	17
1

Cell Formulas
Range	Formula
C3:D4	C3	=SUMIF($A$8:$A$14,$A3,C$8:C$14)
C5:D5	C5	=SUM(C3:C4)

I like that! I'll give that a try. Thank you Stephen