Home |
Search |
Today's Posts |
#1
|
|||
|
|||
continuous sum formula needed
I have a column of numbers, with a simple SUM formula at the bottom, to which
I need to add new rows from time to time. How can I get the sum formula to recognize an added row so the calculation is correct rather that changing the formula manually? |
#2
|
|||
|
|||
continuous sum formula needed
Insert one extra line. You could fill it with ***.
Include this line in the SUM formula. If you need to insert new lines, insert them above the *** line. Your SUM formula will be adjusted automatically. -- Kind regards, Niek Otten "NN" wrote in message ... I have a column of numbers, with a simple SUM formula at the bottom, to which I need to add new rows from time to time. How can I get the sum formula to recognize an added row so the calculation is correct rather that changing the formula manually? |
#3
|
|||
|
|||
continuous sum formula needed
Another option would be to sum the entire column -- but then you'd have to
put your total in a different column. This would look like: sum(B:B) if you were summing column B. Another alternative, if you really want the sum to be at the bottom of the column, you can use this formula in Cell B7. If you insert rows above it, it should stay okay. =SUM($B$1:INDIRECT(CELL("address",OFFSET(B7,-1,0)))) Art "NN" wrote: I have a column of numbers, with a simple SUM formula at the bottom, to which I need to add new rows from time to time. How can I get the sum formula to recognize an added row so the calculation is correct rather that changing the formula manually? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula or Macro needed? | Excel Discussion (Misc queries) | |||
Formula needed to compare columns | New Users to Excel | |||
More Help Needed with Count formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula needed | Excel Worksheet Functions |