Excel Loan Tracking Formulas - Need Help with Dynamic Updates

Mohammad Sanim

New Member
Joined
Feb 25, 2025
Messages
1
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hi everyone,

I'm trying to create a loan tracking sheet in Excel, but I'm having trouble with the formulas. I want to track the loans I've taken, the payments I make, and the remaining balance for each loan. I need the "Total Paid" and "Remaining Balance" columns to automatically update whenever I add a new payment with a different person.
I've tried using the SUMIF formula, but it's not updating correctly when I add new payments. I'm also not sure how to calculate the remaining balance based on the original loan amount.

Can someone please help me with the correct formulas? I need them to automatically update when I add new rows with payments.

Thanks in advance for your help!
 

Attachments

  • Screenshot 2025-02-25 224041.png
    Screenshot 2025-02-25 224041.png
    65.9 KB · Views: 13

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
Back
Top