This can be done but is fraught with danger.

There will be no "paper trail" for error-checking and no way to recover from
errors without starting over.

See John McGimpsey's site for methods.

http://www.mcgimpsey.com/excel/accumulator.html


Gord Dibben MS Excel MVP

On Thu, 27 Dec 2007 12:26:00 -0800, MartyM
wrote:

Hello:

I need to set up a spreadsheet that maintains a running balance in a single
cell. For example, in cell A1 "50,000" will be displayed. When a number "x"
is entered into any cell in the range A2:C30, A1 will then display the value
of 50,000-x. I'm basically trying to set up a budget sheet that keeps a
running budget balance everytime a new expense is added.

Thank you all in advance.