Budget/debt sheet help!!!!

[Heatherleveridge]

Ok so I have my monthly bills on one sheet and my overall debt on the second sheet and I want some way to tell excel when I pay a monthly bill and it automatically take that amount off the total debt on the second page. I cannot figure out a way to tell excel when I make a payment.
So in my photos I have it written next to Navient how much I owe each month on sheet one, but I want some way to tell excel when I pay them. And once I mark that it’s paid have a formula on the second sheet under total amount left that will automatically subtract it.
Please help!

 

[Heatherleveridge]

Anything where you are constantly having to add new columns is going to be a huge pain to maintain. You may have to update your formulas every time, unless you come up with some elaborate formula or VBA solution.

I think it would be better to have a structure of just 4 columns for the payment history, with these columns:
Entity
Payment for Month
Payment Date
Payment Amount

Then as new payments are being made, you don't need to add new columns, just new rows.
This sort of structure would be very conducive to using SUMIF (or SUMIFS) functions like I described in my first reply.

that makes a lot more sense! thank you!

 

[Joe4]

You are welcome.