Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Running Balance in Microsoft Excel?
I am developing a ledger sheet in excel and facing problem in running balance because normally its formula is:
Openinig Balance (A) = 100
Line 1 (B) = A+B
Line 2 (C) = B+C
Line 3 (D) = C+D
but when i insert a blank row in between all downward formulas disturbed. so i need such solution which will helpful in excel.
1 Answer
- nospamcwtLv 51 decade agoFavorite Answer
Alright, I've got a solution. If column A has deposits/withdrawls(-) and column B is the running balance, put the opening balance at the top of column A and use the following formula for column b, starting at B1:
=SUM(A$1:A1)
Now you can copy the formula down. When you insert a row, just copy the formula into the new empty cell in column B.
It works because SUM adds all the values from the fixed A1 cell (the $ forces the 1 to remain fixed) up to the current cell. A1 becomes A2 when the formula is copied to B2, A3 in B3, and so on.
