Distribute an amount across multiple rows in a column until 0|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello

I have a supplier wise spreadsheet with date wise multiple Bill Amounts in multiple rows in Column C. After the credit period is over, I enter lumpsum payment amount (which does not match the individual bill amounts) in Column F and I want the payment amount to settle bill amounts in each row until its consumed completely i.e. 0.

Sometimes, the payment shall be made after a series of bills are entered i.e. there might be 6-7 bill rows above the payment row and it has to pick up the last unpaid or partly paid bill and start settling from there down.

I saw a post in this form that had the amount spread horizontally across multiple columns, but I am struggling to convert that logic to spread across multiple rows. I am attaching a sample sheet for your reference.

Would appreciate any help from you.

Thanks