![]() |
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? |
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