On Jan 19, 5:28 pm, wrote:
Harvey wrote:
This seems to be a very simple thing.
I have a list of numbers and the next colum over is a running total.
If I delete a line (or insert, etc) the references become incorrect.
I always want the formula to reference the previous cell (above) in the
running total column.I wonder if this meets your needs:

offset(B5,-1,-1)

assuming that appears in B5 itself. That references the cell in the
row above and the column to the left. If you copy the formula, B5
should be updated appropriately.

Good! Thanks.
That got me to this

=B5+OFFSET(C5,-1,0)

Which works great.
Now I can delete or move a row with no problem.

Harvey