Thanks:  0
Likes:  0

# Thread: Sum problem when insert new row

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)

Many thanks to those who help

2. 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
Microsoft Excel/VBA Training

[ This Message was edited by: Dave Hawley on 2002-03-26 02:47 ]

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

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

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•