Excel Loan Tracking Formulas - Need Help with Dynamic Updates

[Mohammad Sanim]

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!

 

[johnny51981]

So I am thinking that your values aren't actually values, which is why they are left justified where values are always right justified. Removing the commas would resolve that and allow your SUMIF formulas to work as expected.

 

[Mohammad Sanim]

So I am thinking that your values aren't actually values, which is why they are left justified where values are always right justified. Removing the commas would resolve that and allow your SUMIF formulas to work as expected.

View attachment 123311

Thanks for your kind and try to help me. I am very happy to see this. But I already solved this problem after a lot of time spent in this sheet. And you are right but I noticed this after a long time but my long taught me very much, With this time I made my sheet way more advanced as i not expected.

 

[Mohammad Sanim]

Thanks for your kind and try to help me. I am very happy to see this. But I already solved this problem after a lot of time spent in this sheet. And you are right but I noticed this after a long time but my long taught me very much, With this time I made my sheet way more advanced as i not expected.

Also I forgot to tell you this that I am a beginner, And this sheet is my first project. And It's comes with many problem. But I learn many things from this excel sheet.