Auto Calculate Amount Remaining

[Capsaicin Burn]

	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

 

[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