Formula for the inverse of SUMIF

I have two worksheets. One is the planning sheet and the other is production sheet. Both sheets have two common column headers i.e. Order Number and Article Name. What's missing in the production sheet is Delivery Date (single order have multiple delivery dates). For example:

Production sheet contains following:

Order Number = 1234
Article Name = ABCD
Order Quantity = 100,000
Production Quantity = 80,000

Planning sheet contains following:

Order Number = 1234
Article Name = ABCD
Delivery Date = 01-Aug-2020
Order Quantity = 25,000
Produced Quantity = ______
Delivery Date = 01-Sep-2020
Order Quantity = 25,000
Produced Quantity = ______
Delivery Date = 01-Oct-2020
Order Quantity = 25,000
Produced Quantity = ______
Delivery Date = 01-Nov-2020
Order Quantity = 25,000
Produced Quantity = ______

I need the produced quantity in Planning sheet such that the sum of all the breakups is equal to the total produced quantity in Production Sheet.

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Try in F3 then drag down:

Please Login or Register  to view this content.

Opp, sorry it is my fail. I coppied the table from production sheet in to planning sheet for illutration.
Try again:

Please Login or Register  to view this content.

With 1st SUMIFS get the limitation, then subtract the accumulative QTY (2nd SUMIFS), to compare with current order qty then get the smaller. Then copare with zero to get value bigger than 0