Auto Calculate Amount Remaining

[Capsaicin Burn]

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Debt
[/TD]
[TD]Payment
[/TD]
[TD]Due
[/TD]
[TD]Jun
[/TD]
[TD]Jul
[/TD]
[TD]Aug
[/TD]
[TD]Sep
[/TD]
[TD]Oct
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Loan
[/TD]
[TD]$75
[/TD]
[TD]1st
[/TD]
[TD="align: center"]Y
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]CC1
[/TD]
[TD]$25
[/TD]
[TD]4th
[/TD]
[TD="align: center"]Y
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]CC2
[/TD]
[TD]$25
[/TD]
[TD]10th
[/TD]
[TD="align: center"]Y
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]CC3
[/TD]
[TD]$30
[/TD]
[TD]15th
[/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]Internet
[/TD]
[TD]$75
[/TD]
[TD]20th
[/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]Cell
[/TD]
[TD]$100
[/TD]
[TD]21st
[/TD]
[TD="align: center"]Y
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]Ins
[/TD]
[TD]$100
[/TD]
[TD]24th
[/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]Car
[/TD]
[TD]$350
[/TD]
[TD]28th
[/TD]
[TD="align: center"]Y
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]Total
[/TD]
[TD]$625
[/TD]
[TD]Remaining
[/TD]
[TD="align: center"]$205
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


















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

 

[Twollaston]

The debts don't change often but they do change. Putting the row at the top to avoid editing it is genius. I would have never thought of that or realized the value of that simple mod. That is why I ask the experts! Thanks once again!

No problem, happy to help you