I usually keep an empty row or column between the data and the cell
containing the formula if I expect that I wil insert rows or columns in
the future. In the formula I include the empty cell. If I then need to
insert a new cell in the range it will also extend the formula.
In your example I would have the data in B2:B8, leave B9 blank and put
the formula =SUM(B2:B9) in B10.
As you do this you must keep in mind what the formula does that you use.
In the above example it works just fine, because an empty cell makes no
difference to the result. But in other functions that might be different.
Arnold Huzen
Adam Victor Nazareth Brandizzi schreef:
Hi, people!
I have a spreadsheet with a list of values, let's say, at the interval
B2:B8. At B9, I have the formula =SUM(B2:B8). If I insert a new row
between B8 and B9, the formula at the now B10 cell is not updated.
Is there a simple way to make this formula automatically update
itself? I'm leaving a blank row between the last value and the sum
cell; I believe I could do some black magic with info functions and
such; also, I know I could use macros, but I'm looking for something
easier, since I'm going to teach it.
Thanks in advance!
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
