Spreadsheet: 864934d1712066958-sumifs-indirect-name-error-excel_issue
Sheet: OTD_Data

DeliveryNoteNumber | DeliveryNoteItem | DeliveryDate | Month Name | Year | LookupData | PartNumber | ProductDescription | SalesOrderNumber | SalesOrderItem | DateRequired | WorksOrderNumber | QuantityDelivered | InvoiceNumber | DaysEarlyOnTime | DelCustomerName | CustomerOrderRef | OTD_Status | OTD_MC_Status | Delivery_Mouth_Year | Week | Delivery_Week_Year | CustomerAccountCode | ProjectCode | DaysLateOnTime | EarlyDate | LateDate | Delivery+Performance | Period | DaysLate | SalesKPI_LookUp
020889 | 4 | 44971 | February | 2023 | February-2023 | [PHONE]-40 | CE ACP 100MM GAS CAP  SAE #5 -40 | S104305 | 3 | 45014 | 0 | 1 | 00020533 | 7 | Parker Hannifin Emea Sarl (Poland) | 54650719OP | Not On Time | Ontime | 44958 | 7 | 2023 | PAR002 |  | 0 | 45007 | 45014 | On Time | 2023-2 | -43 | 2023-Parker Hannifin [NAME] (Poland)
020958 | 4 | 44979 | February | 2023 | February-2023 | 120D181470.002.0 G | SHEET GOLD | S106785 | 9 | 45289 | 0 | 1 | 00020664 | 9999 | Mtl Advanced Ltd | GOLD PARTS | Ontime | Ontime | 44958 | 8 | 2023 | MTL002 |  | 1 | 35290 | 45290 | On Time | 2023-2 | -310 | 2023-Mtl Advanced Ltd
020958 | 5 | 44979 | February | 2023 | February-2023 | 120D181480.001.0FZ G | SHEET GOLD | S106785 | 10 | 45289 | 0 | 1 | 00020664 | 9999 | Mtl Advanced Ltd | GOLD PARTS | Ontime | Ontime | 44958 | 8 | 2023 | MTL002 |  | 1 | 35290 | 45290 | On Time | 2023-2 | -310 | 2023-Mtl Advanced Ltd
020958 | 2 | 44979 | February | 2023 | February-2023 | 120D181431.001.0FZ G | BLECH SHEET GOLD | S106785 | 8 | 45289 | 0 | 1 | 00020664 | 9999 | Mtl Advanced Ltd | GOLD PARTS | Ontime | Ontime | 44958 | 8 | 2023 | MTL002 |  | 1 | 35290 | 45290 | On Time | 2023-2 | -310 | 2023-Mtl Advanced Ltd
020958 | 1 | 44979 | February | 2023 | February-2023 | 120D181400.008.0FZ G | PLATE LH GOLD | S106785 | 3 | 45289 | 0 | 1 | 00020664 | 9999 | Mtl Advanced Ltd | GOLD PARTS | Ontime | Ontime | 44958 | 8 | 2023 | MTL002 |  | 1 | 35290 | 45290 | On Time | 2023-2 | -310 | 2023-Mtl Advanced Ltd
020953 | 1 | 44979 | February | 2023 | February-2023 | SCRAP CARBIDE | SCRAP CARBIDE TIPS PER KG | S106784 | 1 | 44981 | 0 | 268 | 00020661 | 9999 | Cutting & Wear | 2036568 | Ontime | Ontime | 44958 | 8 | 2023 | CUT001 |  | 1 | 34982 | 44982 | On Time | 2023-2 | -2 | 2023-Cutting & Wear
020958 | 3 | 44979 | February | 2023 | February-2023 | 200D181310.007.0 G | SHEET GOLD | S106785 | 14 | 45289 | 0 | 1 | 00020664 | 9999 | Mtl Advanced Ltd | GOLD PARTS | Ontime | Ontime | 44958 | 8 | 2023 | MTL002 |  | 1 | 35290 | 45290 | On Time | 2023-2 | -310 | 2023-Mtl Advanced Ltd
020958 | 6 | 44979 | February | 2023 | February-2023 | 120D181000.015.0FZ G | SHEET RH GOLD | S106785 | 1 | 45289 | 0 | 1 | 00020664 | 9999 | Mtl Advanced Ltd | GOLD PARTS | Ontime | Ontime | 44958 | 8 | 2023 | MTL002 |  | 1 | 35290 | 45290 | On Time | 2023-2 | -310 | 2023-Mtl Advanced Ltd
020958 | 7 | 44979 | February | 2023 | February-2023 | 120D181000.016.0FZ G | SHEET LH GOLD | S106785 | 2 | 45289 | 0 | 1 | 00020664 | 9999 | Mtl Advanced Ltd | GOLD PARTS | Ontime | Ontime | 44958 | 8 | 2023 | MTL002 |  | 1 | 35290 | 45290 | On Time | 2023-2 | -310 | 2023-Mtl Advanced Ltd
020783 | 1 | 44957 | January | 2023 | January-2023 | D4914 | D4914 | S102839 | 1 | 44890 | 5722 | 5 | 00020498 | 9999 | Schlumberger [NAME] | [PHONE] | Not On Time | Not On Time | 44927 | 5 | 2023 | SCH001 |  | 1 | 34891 | 44891 | Late | 2023-1 | 67 | 2023-Schlumberger Oilfield Uk PLC
020787 | 1 | 44957 | January | 2023 | January-2023 | D4914 | D4914 | S102839 | 2 | 44897 | 5728 | 5 | 00020501 | 9999 | Schlumberger [NAME] | [PHONE] | Not On Time | Not On Time | 44927 | 5 | 2023 | SCH001 |  | 1 | 34898 | 44898 | Late | 2023-1 | 60 | 2023-Schlumberger Oilfield Uk PLC
020784 | 1 | 44957 | January | 2023 | January-2023 | D4914 | D4914 | S102839 | 1 | 44890 | 5723 | 5 | 00020499 | 9999 | Schlumberger [NAME] | [PHONE] | Not On Time | Not On Time | 44927 | 5 | 2023 | SCH001 |  | 1 | 34891 | 44891 | Late | 2023-1 | 67 | 2023-Schlumberger Oilfield Uk PLC
020788 | 1 | 44957 | January | 2023 | January-2023 | D4914 | D4914 | S102839 | 2 | 44897 | 5729 | 5 | 00020502 | 9999 | Schlumberger [NAME] | [PHONE] | Not On Time | Not On Time | 44927 | 5 | 2023 | SCH001 |  | 1 | 34898 | 44898 | Late | 2023-1 | 60 | 2023-Schlumberger Oilfield Uk PLC
020786 | 1 | 44957 | January | 2023 | January-2023 | D4914 | D4914 | S102839 | 2 | 44897 | 5727 | 5 | 00020500 | 9999 | Schlumberger [NAME] | [PHONE] | Not On Time | Not On Time | 44927 | 5 | 2023 | SCH001 |  | 1 | 34898 | 44898 | Late | 2023-1 | 60 | 2023-Schlumberger Oilfield Uk PLC
020790 | 1 | 44957 | January | 2023 | January-2023 | D4914 | D4914 | S102839 | 2 | 44897 | 5731 | 5 | 00020504 | 9999 | Schlumberger [NAME] | [PHONE] | Not On Time | Not On Time | 44927 | 5 | 2023 | SCH001 |  | 1 | 34898 | 44898 | Late | 2023-1 | 60 | 2023-Schlumberger Oilfield Uk PLC
020789 | 1 | 44957 | January | 2023 | January-2023 | D4914 | D4914 | S102839 | 2 | 44897 | 5730 | 5 | 00020503 | 9999 | Schlumberger [NAME] | [PHONE] | Not On Time | Not On Time | 44927 | 5 | 2023 | SCH001 |  | 1 | 34898 | 44898 | Late | 2023-1 | 60 | 2023-Schlumberger Oilfield Uk PLC