Running Balance in One Cell
 

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.
--
MartyM

Running Balance in One Cell
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MartyM" wrote in message
...
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.
--
MartyM

Running Balance in One Cell
 

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.
--
MartyM


"Don Guillett" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MartyM" wrote in message
...
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.
--
MartyM

Running Balance in One Cell
 

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.