Hi Cris

Providing the insertion is made between rows 1 and 14, the formula will
expand automatically to include the widened range.
If the user choose to highlight row 15, then the formula will not adjust.
There are numerous ways of overcoming this.
You could put your formula on row 16 and make it =SUM(A1:A15) and in row
15 FormatCellsAlignmentHorizontalFill.
Typing an = sign in the cell will fill it with ======== to indicate that
this is the row being totaled to.

Regards

Roger Govier



Cris B. wrote:

I have numerical data in column A rows 1:14.

I'm adding it up in row 15. Sum=(A1:A14)

Now I've been asked to insert more rows with data above row A14.

What can I put in my Sum formula in place of A14 so when I insert
a new row, any numerical data above it in column A automatically adds up?
Sum=(A1:????)

I don't want to have to go and change it to sum=(A1:A17) if I
insert 3 rows.... I have a huge file to create with sections like this. User
may have to insert new rows. They need to all add up.