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?
|