Split amount paid by invoice (formula)

[Drskers]

Hello all,

I would like to have your assistance about the file attached.

I want to create a simple formula (except sumif/s) to fill automatically the yellow cells with the correct amount until it sums the total amount paid.

Thank you very much,
Drskers

now with the file attached (thanks for the assistance Richard Buttrey)
Attachment 640422

[Richard Buttrey]

Hi and welcome to the forum.

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. Pictures are rarely much use and no one wants to recreate something you already have.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

[Bosco]

Perhaps,

In D2, copied down :

=IF(SUMIF(A$1:A2,A2,C$1:C2)<=VLOOKUP(A2,$F$2:$G$3,2,0),C2,MAX(0,VLOOKUP(A2,$F$2:$G$3,2,0)-SUMIF(A$1:A1,A2,C$1:C1)))

Regards
Bosco