Automatically update formula (sum) when inserting row
 

I have very simple spreadsheet with 5 columns. Last cell in each column is
sum of cells above it using =SUM. I thought the formula would update
automatically when I insert rows so that the new row cell would be added to
the sum but this isn't happening. Automatic calculation is checked. What
else do I need to do?

Automatically update formula (sum) when inserting row
 

Enter formula in column A then drag across to column E.

=SUM(A1:INDEX(A:A,ROW()-1))


Gord Dibben MS Excel MVP


On Thu, 19 Oct 2006 11:38:02 -0700, Cheri D. <Cheri
wrote:

I have very simple spreadsheet with 5 columns. Last cell in each column is
sum of cells above it using =SUM. I thought the formula would update
automatically when I insert rows so that the new row cell would be added to
the sum but this isn't happening. Automatic calculation is checked. What
else do I need to do?

Automatically update formula (sum) when inserting row
 

Cheri,

If you're adding a row between the cell with the SUM in it and the last row
of the cells being summed, SUM won't catch it because it's outside the range
of the SUM function. For example, if you are summing cells A10:A17, and the
SUM function is in cell A18, and you try to insert a row between A17 an A18,
SUM won't update to include it. If you try to insert a row between A16 and
A17, SUM will include it. The same applies for the top of the range.


"Cheri D." wrote:

I have very simple spreadsheet with 5 columns. Last cell in each column is
sum of cells above it using =SUM. I thought the formula would update
automatically when I insert rows so that the new row cell would be added to
the sum but this isn't happening. Automatic calculation is checked. What
else do I need to do?