ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Running Balance in a row (https://www.excelbanter.com/excel-discussion-misc-queries/253987-running-balance-row.html)

SiH23

Running Balance in a row
 
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?

David Biddulph[_2_]

Running Balance in a row
 
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.
--
David Biddulph

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





All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com