sum if with condition
Hi all, please kindly help me create this excel formula
this is the source of data:
Disburse AmountStatusRp300.000.000OngoingRp500.000.000OngoingRp200.000.000OngoingRp150.000.000PaidRp20.000.000Late
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
Hi all, please kindly help me create this excel formulathis is the source of data:Disburse AmountStatusRp300.000.000OngoingRp500.000.000OngoingRp200.000.000OngoingRp150.000.000PaidRp20.000.000Late the formula i want to createUmbrella 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 Read More
