Jun 03 2024 03:36 AM
Hi all, please kindly help me create this excel formula
this is the source of data:
Disburse Amount | Status |
Rp300.000.000 | Ongoing |
Rp500.000.000 | Ongoing |
Rp200.000.000 | Ongoing |
Rp150.000.000 | Paid |
Rp20.000.000 | Late |
the formula i want to create
Umbrella Limit: | Rp 25.000.000.000 (hardcode) |
Loan Paid: | Rp 150.000.000 (all rows with status of "Paid") |
Loan Outstanding: | Rp 1.000.000.000 (all 3 rows with status of "ongoing") |
Available Limit: | umbrella limit: all "ongoing" and "late" rows. which is Rp 1.020.000.000. and i want this available limit to exclude the "Paid" row from the source data |
the formula i want to create is the Loan Paid , Loan Outstanding and Available limit.
thanks
Jun 03 2024 03:47 AM
Hi, you can use the SUMIF function for that. Please see attached sample document with the proposed solution.
Martin