Insert row above Sum - update formula

[Guest]

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

 

[Bob Phillips]

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)