Capsaicin Burn
New Member
- Joined
- Jan 26, 2018
- Messages
- 38
A | B | C | D | E | F | G | H | |
1 | Debt | Payment | Due | Jun | Jul | Aug | Sep | Oct |
2 | Loan | $75 | 1st | Y | ||||
3 | CC1 | $25 | 4th | Y | ||||
4 | CC2 | $25 | 10th | Y | ||||
5 | CC3 | $30 | 15th | |||||
6 | Internet | $75 | 20th | |||||
7 | Cell | $100 | 21st | Y | ||||
8 | Ins | $100 | 24th | |||||
9 | Car | $350 | 28th | Y | ||||
10 | Total | $625 | Remaining | $205 |
<tbody>
</tbody>
Columns A,B and C never change
My dilemma is making row 10 auto calculate and populate what is still due each month.
I simply mark each debt with a Y to indicate "Yes it has been paid". A blank cell indicates it has NOT been paid.
Currently I just add it up manually after each payment is made. I would like it to figure out, and update, the amount remaining as I make payments. How to make it calculate automatically has baffled me to date.
Any Help would be greatly appreciated!
Jim