Heatherleveridge

New Member
Joined
Dec 31, 2020
Messages
6
Office Version
  1. 365
Platform
  1. Windows
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!
 

Attachments

  • naviant.PNG
    naviant.PNG
    16.3 KB · Views: 5
  • amount left.PNG
    amount left.PNG
    5.5 KB · Views: 5

Heatherleveridge

New Member
Joined
Dec 31, 2020
Messages
6
Office Version
  1. 365
Platform
  1. Windows
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!
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,715
Office Version
  1. 365
Platform
  1. Windows
You are welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,994
Messages
5,628,029
Members
416,287
Latest member
wanji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top