Try this:

=SUM($A$1:A1)

And copy down as needed.

OK for deletes.
If you insert, you must of course copy the formula into the new rows.

Also, wouldn't advise using this formula if you're totaling more then 3 or 4
thousand rows.

It's hard on the system, but for small ranges it's OK.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Harvey" wrote in message
ups.com...
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.
Thanks
Harvey