Split Amount According to Voucher Number

Hi,
i have some payment detail in K4:K5000,
and voucher wise amount detail in E4:E5000

i want first some of the Amount from K4:K5000 according to Criteria range J4:J5000

And then the sum ammount is spilt to the party voucher wise,

for example

in range j4:j5000 = AL SAFA 01 / AAM = 1300000 + 100000 + 100000 = 3300000

THEN this amount 3300000 spilt to range e4:e5000

Screenshot_1.jpgScreenshot_2.jpg

Try this:

=IFERROR(1/(1/MAX(0,IF(SUMIF(D$4:D4,D4,E$4:E4)<SUMIF(J:J,D4,K:K),F4,SUMIF(J:J,D4,K:K)-SUMIF(D3:D$4,D4,E3:E$4)))),"")

copied down. Please try to remember to keep sample files SMALL (10-20 rows, not hundreds and NEVER thousands!!)

Sir,
Thanks for the reply and the solution of my problem,

there is little problem in formula,
i add a peyment to
j35 = AL QURESH FOOD 441
K35 = 1533706

but first amount in g31 = 1000000 not showing in formula, while second amount g32 = 533706 is showing,

this problem is in many payment detail

please check

Screenshot_1.jpg

same problem here

Screenshot_2.jpg

Here is another solution:

Please try in F4 and copy down:

Formula:

=IFERROR(1/(1/MAX(0,MIN(E4,SUMIF(J$4:J$99,D4,K$4:K$99)-SUMIF(D$3:D3,D4,E$3:E3)))),"")

Thank you very very much sir,

its working great now

Thanks for the feedback and rep . Glad to have helped.