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?