Running Balance in One Cell

[MartyM]

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.

 

[Don Guillett]

Have you tried
=50000-SUM(a2:c30)

 

[MartyM]

You've made my day - thank you. I've been searching various "Help" sections
and trying different formulas. I had =SUM(50000-(A1:C30)) at one point but
didn't think to change the order. Thanks again and Happy New Year.

 

[Gord Dibben]

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