Sum problem when insert new row

[chaju]

Please help!
Suppose in:
Cell A1 --> 10
Cell A2 --> 20
Cell A3 --> 30
Cell A4 --> =sum(A1:A3)

If I have edit a new row at row 4 and enter 40 in the new Cell A4,
Cell A1 --> 10
Cell A2 --> 20
Cell A3 --> 30
Cell A4 --> 40
Cell A5 --> =sum(A1:A3)

The problem arise such that the sum formula in cell A5 does not include the value in the new row added. or change to =sum(A1:A4)

Any Advise??

Many thanks to those who help

 

[Dave Hawley]

Just put your SUM Function is cell A5 instead, this way you will always have a blank row between your data and your formula. Use this row to add more.



_________________
Kind Regards
Dave Hawley
OzGrid Business Applications
Microsoft Excel/VBA Training

This message was edited by Dave Hawley on 2002-03-26 02:47

 

[Legacy 1363]

Or alternatively (no need to maintain a blank row), put in A4 :-

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