consume amount inorder

[hussein_elsayed]

Dears,

Could you please assist regarding the below sample. i have series of amounts and i want to consume them inorder based on the paid amount with formula to be like the below ex)

1	2	3	4	5	6	7	8	total Dues
136,579.84	36,808.15	51,255.31	33,533.46	16,004.24	38,333.13	20,611.28	2,889.43	336,014.86
							Paid	254,352.70	81,662.16
To Be
-	-	-	3,824.07	16,004.24	38,333.13	20,611.28	2,889.43	81,662.16

[#2 · Accepted solution]

@hussein_elsayed try this:

=MAX(0,B$2-MAX(0,$J$3-SUM($A$2:A$2)))

[#3]

Thanks! You’re awesome.