[OP]
Member
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.
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.
Lee Schierer
USNA '71
Go Navy!
My advice, comments and suggestions are free, but it costs money to run the site. If you found something of value here please give a little something back by becoming a contributor! Please Contribute
Contributor
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)
- Mike
Si vis pacem, para bellum
Contributor
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
Posting Permissions
Reply With Quote