Mohammad Sanim
New Member
- Joined
- Feb 25, 2025
- Messages
- 1
- Office Version
- 365
- 2010
- Platform
- 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!
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!