Running Balance in a row


S

SiH23

I'd be most grateful if someone could help.

I need to calculate a running balance in a row of cells.

I need a formula in Cell B1 that will add the value in Cell A1 to the value
placed in Cell B1, next a formula in cell C1 that will add the value in Cell
B1 and the value in Cell C1 itself and so on... Is there anyway of doing this
without getting the circular cell referene warning coming up?
 
Ad

Advertisements

D

David Biddulph

If B1 has a value it can't also contain a formula; the same for C1.

Put your running total in row 2.
=SUM($A1:A1) in A2 and copy across.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running Balances 3
Running Balance 3
running balances 3
to keep a running balance 3
sorted running balance 2
Subtracting a running Balance 1
TABLE WITH RUNNING BALANCE 2
Hide rows with zero balances 11

Top