Inserting rows and AutoSum (Excel 2002 SP3)

Topic

New Reply

I have a simple spreadsheet with a few rows of numbers in a column, say A1 to A5 with an AutoSum =SUM(A1:A5) in cell A6. I then insert a new row, so my AutoSum is now in cell A7, but it still reads =SUM(A1:A5). I seem to recall that Excel used to always automatically adjust the formula to take account of the inserted row … am I dreaming?
Your assistance would be greatly appreciated.

Reply | Quote

Replies

If your cursor was in A6 when you inserted, then the formula wouldn’t be adjusted automatically to include A1:A6. Same way if you put your cursor in the first row, the formula will go to A2:A6. Is this maybe what you were doing? If you put the cursor in rows 2, 3, 4, or 5 (in your example), it would adjust the formula to A1:A6 automatically.

Reply | Quote

Of course I wanted another row at the end of the list, so I inserted the new row at A6.
Thank you for your prompt assistance.

Reply | Quote

Of course I wanted another row at the end of the list, so I inserted the new row at A6.
Thank you for your prompt assistance.

Reply | Quote

If your cursor was in A6 when you inserted, then the formula wouldn’t be adjusted automatically to include A1:A6. Same way if you put your cursor in the first row, the formula will go to A2:A6. Is this maybe what you were doing? If you put the cursor in rows 2, 3, 4, or 5 (in your example), it would adjust the formula to A1:A6 automatically.

Reply | Quote