Sum problem when insert new row

chaju · Mar 26th, 2002, 03:35 AM

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 · Mar 26th, 2002, 03:44 AM

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 ]

C. O. Jones · Mar 26th, 2002, 04:41 AM

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 26th, 2002, 03:35 AM	#1
chaju Board Regular Join Date: Mar 2002 Posts: 82	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

Mar 26th, 2002, 03:44 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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 ]

Mar 26th, 2002, 04:41 AM	#3
C. O. Jones Join Date: Mar 2002 Posts: 372	Or alternatively (no need to maintain a blank row), put in A4 :- =SUM(A1:OFFSET(A4,-1,0))