Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Copying formula with cell reference decreasing automatically | Excel Discussion (Misc queries) | |||
Cell Ref. in Formula changes automatically | Excel Worksheet Functions | |||
How can a formula in a cell automatically update when inserting a. | Excel Worksheet Functions | |||
Can I set up the formula to update automatically? | Excel Worksheet Functions |