Insert row above Sum - update formula
 

Row value
A1 12
A2 10
A3 6
A4 4
A5 Sum(A1:A4) = 32

I want to insert a row above row 5, but the sum function needs to change to
Sum(A1:A5).
Any ideas

Insert row above Sum - update formula
 

Use a formula of

=SUM(A1:OFFSET(A5,-1,0))


--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Saintsman" wrote in message
...
Row value
A1 12
A2 10
A3 6
A4 4
A5 Sum(A1:A4) = 32

I want to insert a row above row 5, but the sum function needs to change
to
Sum(A1:A5).
Any ideas