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
Chuck
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.