View Full Version : Excel question....

Chuck Wintle
02-16-2013, 10:17 AM
How would I do a running total for deposits into a saving plan so that i can see the increment for each month? I can do it but its a pain...I need add each preceding cell from when the plan started. I know there is always a better method. Thank in advance.

Lee Schierer
02-16-2013, 10:44 AM
If your put your deposits on row 1 and the total on row 2 then in cell A2 type in =A1
You can get a running total by typing in the following to cell B2. =a2+b1
Then copy cell B2 to the right for as many cells as you need.

Mike Cogswell
02-16-2013, 11:31 AM

Are you making multiple deposits during a month and looking for a subtotal showing each months increment, or are you looking for a running total since inception? (or both)

George Bokros
02-16-2013, 11:44 AM
Try this:

The following are column headings:

Column A Row 1 -- Date
Column B Row 1 -- Deposit Amount
Column C Row 1 -- Earnings.
Column D Row 1 -- Balance

Formulas all in column D

Row 2 Enter this formula in cell D2 B2+C2
Row 3 Enter this formula in cell D3 = D2+B3+C3
Row 4 Enter this formula in cell D4 D3+B4+C4

Copy and paste the formula from cell D4 to all rows