Remaining quantity calculation

Hello,

I would need your support regarding remaining quantity calculation, please see the details and expected results in the attached file.

Thank you in advance for that!

Try

=INDEX($J$10:$J$13,MATCH(C10&D10,$H$10:$H$13&$I$10:$I$13,0))-SUMIFS($E$10:E10,$C$10:C10,C10,$D$10:D10,D10)

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Going off of John's solutions provided in post #2, here are two non-array formulas:

=SUMIFS(J$10:J$13,H$10:H$13,C10,I$10:I$13,D10)-SUMIFS(E$10:E10,C$10:C10,C10,D$10:D10,D10)

=INDEX($J$10:$J$13,INDEX(MATCH(C10&D10,$H$10:$H$13&$I$10:$I$13,0),0))-SUMIFS($E$10:E10,$C$10:C10,C10,$D$10:D10,D10)

Thank you the help!

Glad we could help. Thanks for the rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.