Spreadsheet: 783917d1655298897-sumifs-on-counting-dot-lines-forum_ex
Sheet: sab_prod

job number | Column1 | item | plant | customer | qty | description | dept | ship-date | job-pln | shp-pln | Price | mch-mat | [NAME] | mch-epl | mch-rtr | ship-act | cancel | mch-cmpl | epl-stock | rtr-stock | misc-stock | edate
[PHONE] | 250 | 250 | SAB | DM STEEL | 2 | MD20 AIRLOCK | M/S | 2022-04-08 00:00:00 | 2022-04-01 00:00:00 |  | 24504 | GI | GI VENT X | SP | MD20,CS,OE,8VN,FR8,CG24,C2 | 2022-04-07 00:00:00 | False | True | True | True | True | April 2022
[PHONE] | 30 | 30 | SAB | BORAL ROOFING LLC | 1 | WEAR RESISTANT MD20 AIRLO | M/S | 2022-06-03 00:00:00 | 2022-06-01 00:00:00 |  | 13100 | GI | RETURN=WR | RETURN=WR | RETURN=WR |  | False | True | True | True | True | June 2022
[PHONE] | 20 | 20 | SAB | RALCORP FROZEN BAKERY | 2 | MD20 AIRLOCK | M/S | 2022-04-08 00:00:00 | 2022-04-01 00:00:00 |  | 9010 | GI | GI | SP | MD20,CS,OE,8VN,FR8,C1 | 2022-04-12 00:00:00 | False | True | True | True | True | April 2022
[PHONE] | 10 | 10 | SAB | WESTLAKE POLYMERS LP | 1 | MD20 AIRLOCK | M/S | 2022-04-08 00:00:00 | 2022-04-01 00:00:00 |  | 8097 | SS | SS | SP X | MD20,SS,OE,8VN,FR8,C1 | 2022-04-07 00:00:00 | False | True | True | True | True | April 2022
[PHONE] | 2801 | 2801 | SAB | NESTLE PURINA PETCARE | 1 | MD20 AIRLOCK | M/S | 2022-04-29 00:00:00 | 2022-04-08 00:00:00 |  | 14652 | GI | DIR DR | SP DIR DR X | MD20,CS,OE,8VN,FR8,CG120,RP,SAF67,C1 | 2022-04-28 00:00:00 | False | True | True | True | True | April 2022
[PHONE] | 10 | 10 | SAB | JOHNSON MATTHEY PROCESS | 1 | MD20 AIRLOCK | M/S | 2022-04-08 00:00:00 | 2022-04-01 00:00:00 |  | 11058 | 304L | 304L X | SP CP 304L X | MD20,SS,CE,8VN,FR8,SPCL | 2022-04-14 00:00:00 | False | True | True | True | True | April 2022
[PHONE] | 10 | 10 | SAB | HEARTLAND FOOD PRODUCTS | 1 | MD20 AIRLOCK | M/S | 2022-05-13 00:00:00 | 2022-05-06 00:00:00 |  | 9628 | SS | SS VNT X | SP X | MD20,SS,OE,8VN,ADJ32,CG80,SPCL 6-8 | 2022-05-18 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 10 | 10 | SAB | EMS CHEMIE NORTH AMERICA INC | 1 | MD20 AIRLOCK | M/S | 2022-04-08 00:00:00 | 2022-04-01 00:00:00 |  | 6550 | SS | SS | SP | MD20,SS,OE,8VN,FR16,C1 | 2022-04-07 00:00:00 | False | True | True | True | True | April 2022
[PHONE] | 2601 | 2601 | SAB | AZEK BUILDING PRODUCTS INC | 1 | MD20 AIRLOCK | M/S | 2022-05-27 00:00:00 | 2022-05-13 00:00:00 |  | 4513 | GI | GI | SP | MD20,CS,OE,8VN,FR8,C1 | 2022-05-24 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 10 | 10 | SAB | MOTION INDUSTRIES | 1 | MD20 AIRLOCK MOTION INDUSTRIES | M/S | 2022-05-27 00:00:00 | 2022-05-20 00:00:00 |  | 3585 | GI | GI | SP | MD20,CS,OE,8VN,ADJ8,C1 | 2022-05-24 00:00:00 | False | True | True | False | True | May 2022
[PHONE] | 20 | 20 | SAB | SOUTHWIRE MC CABLE | 1 | MD20 AIRLOCK | M/S | 2022-05-13 00:00:00 | 2022-05-06 00:00:00 |  | 11484 | SS | SS | SP X | MD20,304L,OE,8VN,FR8,CG24,RV,C1 | 2022-05-11 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 30 | 30 | SAB | SPECTRUM BRANDS PET GROUP INC | 1 | MD20 AIRLOCK | M/S | 2022-06-03 00:00:00 | 2022-06-01 00:00:00 |  | 7362 | SS | SS | SP X | MD20,304L,OE,8VN,FR8,C1 |  | False | True | True | True | True | June 2022
[PHONE] | 1801 | 1801 | SAB | AZEK BUILDING PRODUCTS | 1 | MD20 AIRLOCK | M/S | 2022-05-06 00:00:00 | 2022-05-02 00:00:00 |  | 8799 | GI | GI | SP | MD20,CS,OE,8VN,FR8,CW,C1 | 2022-05-05 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 190 | 190 | SAB | BERRY GLOBAL | 2 | MD20 AIRLOCK | M/S | 2022-04-08 00:00:00 | 2022-04-01 00:00:00 |  | 9602 | GI | GI | SP | MD20,CS,OE,8VN,FR8,CG80,C1 | 2022-04-05 00:00:00 | False | True | True | False | True | April 2022
[PHONE] | 70 | 70 | SAB | AGP | 1 | MD20 AIRLOCK | M/S | 2022-08-26 00:00:00 | 2022-08-19 00:00:00 |  | 6406 |  |  |  |  |  | False | False | False | False | False | August 2022
[PHONE] | 20 | 20 | SAB | POREX CORP | 1 | MD20 AIRLOCK | M/S | 2022-07-15 00:00:00 | 2022-07-08 00:00:00 |  | 4458 | GI | GI | SP TS4 | MD20,CS,OE,8VN,FR8,C1 |  | False | False | False | False | True | July 2022
[PHONE] | 20 | 20 | SAB | SOUTHWIRE COMPANY LLC | 1 | MD20 AIRLOCK | M/S | 2022-06-03 00:00:00 | 2022-06-01 00:00:00 |  | 5761 | GI | GI | SP | MD20,CS,OE,8VN,FR8,CG24,RV,C1 |  | False | True | True | True | True | June 2022
[PHONE] | 20 | 20 | SAB | SOUTHWIRE COMPANY LLC | 1 | MD20 AIRLOCK | M/S | 2022-05-20 00:00:00 | 2022-05-13 00:00:00 |  | 5761 | GI | GI | SP | MD20,CS,OE,8VN,FR8,CG24,RV,C1 | 2022-05-19 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 20 | 20 | SAB | SOUTHWIRE COMPANY LLC | 1 | MD20 AIRLOCK | M/S | 2022-05-20 00:00:00 | 2022-05-13 00:00:00 |  | 5761 | GI | GI | SP | MD20,CS,OE,8VN,FR8,CG24,RV,C1 | 2022-05-16 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 20 | 20 | SAB | SOUTHWIRE COMPANY LLC | 1 | MD20 AIRLOCK | M/S | 2022-05-20 00:00:00 | 2022-05-13 00:00:00 |  | 5761 | GI | GI | SP | MD20,CS,OE,8VN,FR8,CG24,RV,C1 | 2022-05-18 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 10 | 10 | SAB | MOTION INDUSTRIES | 1 | MD20 AIRLOCK | M/S | 2022-06-24 00:00:00 | 2022-06-17 00:00:00 |  | 2707 | GI | GI | SP | MD20,CS,OE,8VN,FR8,C1 |  | False | False | True | False | True | June 2022
[PHONE] | 10 | 10 | SAB | RAGASA INDUSTRIAS SA DE CV | 1 | MD20 AIRLOCK | M/S | 2022-04-08 00:00:00 | 2022-04-01 00:00:00 |  | 3993.3 | GI | GI | SP | MD20,CS,OE,8VN,FR8,C1 | 2022-04-14 00:00:00 | False | True | True | True | True | April 2022
[PHONE] | 10 | 10 | SAB | LANXESS CORPORATION | 1 | MD20 AIRLOCK | M/S | 2022-05-27 00:00:00 | 2022-05-20 00:00:00 |  | 9516 | 316SS | 316SS X | SP X | MD20,316,OE,8VN,FR8,C1 | 2022-05-23 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 10 | 10 | SAB | ICL SPECIALTY PRODUCTS INC | 1 | MD20 AIRLOCK | M/S | 2022-07-01 00:00:00 | 2022-06-24 00:00:00 |  | 16240 | SS | SS | SP CP | RETURN-NEDOX |  | False | False | False | False | True | June 2022
[PHONE] | 10 | 10 | SAB | INGEVITY CORPORATION | 1 | WEAR RESISTANT MD20 AIRLOCK INGEVITY | M/S | 2022-07-22 00:00:00 | 2022-07-15 00:00:00 |  | 9496 | GI | RETURN=WR | RETURN | RETURN=TUNGSTEN |  | False | False | False | False | True | July 2022
[PHONE] | 10.1 | 10.1 | SAB | INGEVITY CORPORATION | 1 | WEAR RESISTANT MD20 AIRLOCK INGEVITY - W.R. | M/S | 2022-07-22 00:00:00 | 2022-05-20 00:00:00 |  |  | GI | GI WR | SP CP | WRMD20,CS,CE8VN,FR8,C1 TUNGSTEN | 2022-05-19 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 10 | 10 | SAB | QUIKRETE COMPANIES | 1 | MD20 AIRLOCK | M/S | 2022-05-13 00:00:00 | 2022-05-06 00:00:00 |  | 2895 | GI | GI | SP | MD20,CS,OE,8VN,FR8,C1 | 2022-05-05 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 10 | 10 | SAB | DANISCO | 1 | MD20 AIRLOCK DANISCO | M/S | 2022-05-20 00:00:00 | 2022-05-13 00:00:00 |  | 7848 | SS | SS VNT PORT X | SP CPX | MD20,.304L,CE,8VN,FR16,CG80,C1 | 2022-05-23 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 10 | 10 | SAB | PILKINGTON NA | 1 | MD20 ROTOR | M/S | 2022-06-10 00:00:00 | 2022-06-03 00:00:00 |  | 1440.6 | CS | NA | NA | MD20,CS,OE,8VN,ADJ8,C1 | 2022-06-03 00:00:00 | False | True | True | True | True | June 2022
[PHONE] | 10 | 10 | SAB | BAGHOUSE & INDUSTRIAL | 4 | MD20 AIRLOCK | M/S | 2022-05-06 00:00:00 | 2022-05-02 00:00:00 |  | 18968 | GI | GI | SP | MD20,CS,OE,8VN,FR16,C3 | 2022-05-02 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 10 | 10 | SAB | BEESING WELDING LLC | 1 | MD20 AIRLOCK | M/S | 2022-06-10 00:00:00 | 2022-06-03 00:00:00 |  | 8432 | GI | GI | SP | MD20,CS,OE,8VN,AJ16,C1 |  | False | True | True | True | True | June 2022
[PHONE] | 30.1 | 30.1 | SAB | BORAL ROOFING LLC | 1 | WEAR RESISTANT MD20 AIRLO - Wear Resistant | M/S | 2022-06-03 00:00:00 | 2022-04-01 00:00:00 |  |  | GI | W.R. | SP CP W.R. | MD20,CS,CE,8VN,FR8,C1,TUNGSTEN X | 2022-04-04 00:00:00 | False | True | True | True | True | April 2022
[PHONE] | 20 | 20 | SAB | CENTRO INCORPORATED | 2 | MD20 AIRLOCK | M/S | 2022-07-15 00:00:00 | 2022-07-08 00:00:00 |  | 8498 | GI | GI | SP TS4 | MD20,CS,OE,8VN,FR8,C1 |  | False | False | False | False | True | July 2022
[PHONE] | 22 | 22 | SAB | NESTLE PURINA PETCARE | 4 | MD20 AIRLOCK | M/S | 2022-05-13 00:00:00 | 2022-05-06 00:00:00 |  | 45388 | GI | GI | SP | MD20,CS,OE,8VN,[NAME],CW,C1 | 2022-05-24 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 10 | 10 | SAB | [NAME] | 1 | M50009,MD20,OE8,FR1/8,GI,DR55,STD   * | M/S | 2022-08-04 00:00:00 | 2022-07-29 00:00:00 |  | 4443 | GI | GI | SP TS4 | MD20,CS,OE,8VN,FR8,C1 |  | False | False | False | False | True | July 2022
[PHONE] | 10 | 10 | SAB | ANCHOR GLASS | 1 | MD20 AIRLOCK ANCHOR GLASS CONTAINER | M/S | 2022-06-24 00:00:00 | 2022-06-17 00:00:00 |  | 4421 | GI | GI | SP | RETURN=NEDOX |  | False | False | True | True | True | June 2022
[PHONE] | 10.1 | 10.1 | SAB | ANCHOR GLASS CONTAINER CORPORATION | 1 | MD20 AIRLOCK ANCHOR GLASS - NEDOX | M/S | 2022-06-24 00:00:00 | 2022-05-13 00:00:00 |  |  | GI | NA | NA | MD20,CS,OE,8VN,[NAME],C1 NEDOX X | 2022-05-17 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 10 | 10 | SAB | HEARTLAND FOOD PRODUCTS | 1 | MD20 AIRLOCK HEARTLAND PET FOOD | M/S | 2022-06-10 00:00:00 | 2022-06-03 00:00:00 |  | 10037 | SS | SS | SP X | MD20,304L,OE,8VN,FR8,CG80,CW,C1 |  | False | True | True | True | True | June 2022
[PHONE] | 10 | 10 | SAB | AMCOR WISCONSIN LLC | 1 | MD20 AIRLOCK | M/S | 2022-06-17 00:00:00 | 2022-06-10 00:00:00 |  | 8977 | SS | SS | SP  X | MD20,304L,CE,8VN,FR8,C1 |  | False | False | True | True | True | June 2022
[PHONE] | 10 | 10 | SAB | MID AMERICA PET FOOD | 2 | MD20 AIRLOCK | M/S | 2022-06-17 00:00:00 | 2022-06-10 00:00:00 |  | 10902 | GI | GI | SP | MD20,CS,OE,8VN,FR8,CG80,C1 |  | False | False | True | True | True | June 2022
[PHONE] | 10 | 10 | SAB | ECOLAB KAY CHEMICAL CO | 1 | MD20 AIRLOCK | M/S | 2022-06-10 00:00:00 | 2022-06-03 00:00:00 |  | 12784 | 316L | 316L [NAME] | SP  32RA X | MD20,316,OE,8VN,FR16,CG150,RV,[NAME] |  | False | False | True | True | True | June 2022
[PHONE] | 10 | 10 | SAB | QUIKRETE | 1 | MD20 AIRLOCK | M/S | 2022-06-17 00:00:00 | 2022-06-10 00:00:00 |  | 2530 | GI | GI | SP | MD20,CS,OE,8VN,FR8,C1 |  | False | False | True | True | True | June 2022
[PHONE] | 10 | 10 | SAB | RB MANUFACTURING LLC | 1 | MD20 AIRLOCK RB MANUFACTURING LLC | M/S | 2022-07-15 00:00:00 | 2022-07-08 00:00:00 |  | 8431 | SS | SS X | [NAME] | MD20,304L,CE,8VN,FR8,C1 |  | False | False | False | False | True | July 2022
[PHONE] | 10 | 10 | SAB | PRAIRIE MALT LIMITED BIGGAR | 1 | MD20 AIRLOCK | M/S | 2022-07-15 00:00:00 | 2022-07-08 00:00:00 |  | 3244 | GI | GI | SP CP TS4 | MD20,CS,OE,8VN,FR8,C1 |  | False | False | False | False | True | July 2022
[PHONE] | 40 | 40 | SAB | ICL SPECIALTY PRODUCTS INC | 1 | MD20 ROTOR | M/S | 2022-07-01 00:00:00 | 2022-06-24 00:00:00 |  | 2519 | SS | NA | NA | RETURN=NEDOX |  | False | False | True | False | True | June 2022
[PHONE] | 10 | 10 | SAB | PHILIP MORRIS USA | 2 | MD20 AIRLOCK PHILIP MORRIS USA | M/S | 2022-07-01 00:00:00 | 2022-06-24 00:00:00 |  | 9168 | GI | GI SPCL FLANGE PATTERN X | SP  DD X | MD20,OE,8VN,FR8,SAF67,C1 |  | False | False | False | False | True | June 2022
[PHONE] | 10 | 10 | SAB | COVESTRO LLC | 1 | MD20 AIRLOCK | M/S | 2022-06-24 00:00:00 | 2022-06-17 00:00:00 |  | 6803 | GI | GI | SP | MD20,CS,OE,8VN,FR8,RV,C1 |  | False | False | True | False | True | June 2022
[PHONE] | 10 | 10 | SAB | CHURCH & DWIGHT CO | 1 | MD20 ROTOR CHURCH & DWIGHT CO | M/S | 2022-06-03 00:00:00 | 2022-05-27 00:00:00 |  | 1643.2 | CS | NA | NA | NEDOX=RETURN | 2022-05-25 00:00:00 | False | True | True | True | True | May 2022
[PHONE] | 10.1 | 10.1 | SAB | CHURCH & DWIGHT CO | 1 | MD20 ROTOR CHURCH & DWIGHT CO | M/S | 2022-05-13 00:00:00 | 2022-04-22 00:00:00 |  | 0 | CS | NA | NA | MD20,CS,OE,8VN,[NAME] | 2022-04-27 00:00:00 | False | True | True | True | True | April 2022
[PHONE] | 10 | 10 | SAB | HEARTLAND FOOD PRODUCTS | 1 | OE8,MD20,FR1/8,C1,80,304/L,CW * | M/S | 2022-04-22 00:00:00 | 2022-04-18 00:00:00 |  | 1505 | 304L | NA | NA | MD20,304L,OE,8VN,FR8,CG80,C1,CW | 2022-04-26 00:00:00 | False | True | True | False | True | April 2022
[PHONE] | 10 | 10 | SAB | INGEVITY CORPORATION | 1 | MD20 AIRLOCK | M/S | 2022-09-09 00:00:00 | 2022-09-02 00:00:00 |  | 6333 |  |  |  |  |  | False | False | False | False | False | September 2022
[PHONE] | 10.1 | 10.1 | SAB | ICL SPECIALTY PRODUCTS INC | 1 | MD20 AIRLOCK - food grade nedox | M/S | 2022-07-01 00:00:00 | 2022-06-17 00:00:00 |  |  | SS | NA | NA | MD20,304L,CE,8VN,FR16,RV,C2 NEDOX X |  | False | False | True | False | True | June 2022
[PHONE] | 10 | 10 | SAB | EBE INDUSTRIAL MFG | 1 | MD20 AIRLOCK | M/S | 2022-06-17 00:00:00 | 2022-06-10 00:00:00 |  | 2285 | GI | GI | SP | MD20,CS,OE,8VN,FR8,C1 |  | False | False | True | True | True | June 2022
[PHONE] | 40.1 | 40.1 | SAB | ICL SPECIALTY PRODUCTS INC | 1 | MD20 ROTOR - food grade nedox | M/S | 2022-07-01 00:00:00 | 2022-06-17 00:00:00 |  |  | 304L | NA | NA | MD20,MD20,304L,CE,8VN,FR16,RV,C1 NEDOX X |  | False | False | True | False | True | June 2022
[PHONE] | 10 | 10 | SAB | EBE INDUSTRIAL MFG | 1 | MD20 AIRLOCK | M/S | 2022-08-05 00:00:00 | 2022-07-29 00:00:00 |  | 3170 | GI | GI | SP TS4 | MD20,CS,OE,8VN,FR16,RP,45^,5-7 |  | False | False | False | False | True | July 2022
[PHONE] | 10 | 10 | SAB | WACKER CHEMICAL CORPORATION | 1 | MD20 AIRLOCK | M/S | 2022-08-12 00:00:00 | 2022-08-05 00:00:00 |  | 14412 | 316SS | 316SS | SP CP TS4 | MD20,316,CE,8VN,FR16,RV,C1 |  | False | False | False | False | True | August 2022
[PHONE] | 20 | 20 | SAB | BERRY GLOBAL | 1 | MD20 AIRLOCK | M/S | 2022-10-21 00:00:00 | 2022-10-14 00:00:00 |  | 6423 |  |  |  |  |  | False | False | False | False | False | October 2022
[PHONE] | 10 | 10 | SAB | [NAME] GYPSUM MFG | 1 | MD20 AIRLOCK | M/S | 2022-08-12 00:00:00 | 2022-08-05 00:00:00 |  | 8226 | GI | GI | SP TS4 | MD20,CS,OE,8VN,FR8,CG24,RP,C1 |  | False | False | False | False | True | August 2022
[PHONE] | 10 | 10 | SAB | COVANTA ENERGY | 1 | MD20 AIRLOCK | M/S | 2022-08-05 00:00:00 | 2022-07-29 00:00:00 |  | 6475 | GI | RETURN=CHROME | RETURN=CHROME | MD20,CS,OE,8VN,AJ16,RV.20,REPLACE,C1 |  | False | False | False | False | False | July 2022
[PHONE] | 10.1 | 10.1 | SAB | COVANTA ENERGY | 1 | MD20 AIRLOCK - HARD CHROME bore & ep interior | M/S | 2022-08-05 00:00:00 | 2022-07-01 00:00:00 |  |  | GI | GI CHROME X | SP  CHROME X | NA |  | False | False | False | True | True | July 2022
[PHONE] | 10 | 10 | SAB | BIG HEART PET BRANDS | 1 | MD20 AIRLOCK | M/S | 2022-06-10 00:00:00 | 2022-06-03 00:00:00 |  | 0 | SS | SS | SP X | MD20,SS,OE,8VN,FR8,CG80,C2 | 2022-06-07 00:00:00 | False | True | True | True | True | June 2022
[PHONE] | 10 | 10 | SAB | [NAME] | 1 | MD20 AIRLOCK | M/S | 2022-07-29 00:00:00 | 2022-07-22 00:00:00 |  | 6424 |  |  |  |  |  | False | False | False | False | False | July 2022
[PHONE] | 40 | 40 | SAB | FLOWCHEM, LLC | 1 | MD20 ROTOR | M/S | 2022-09-30 00:00:00 | 2022-09-23 00:00:00 |  | 666 |  |  |  |  |  | False | False | False | False | False | September 2022
[PHONE] | 10 | 10 | SAB | VAN DIEST SUPPLY CO | 1 | OE8,MD20,FR1/8,C1,80RP,304/L | M/S | 2022-06-29 00:00:00 | 2022-06-24 00:00:00 |  | 1939 | 304L | NA | NA | MD20,304L,OE,8VN,[NAME],C1 |  | False | False | True | False | True | June 2022
[PHONE] | 10 | 10 | SAB | NESTLE PURINA PETCARE | 1 | MD20 AIRLOCK | M/S | 2022-08-12 00:00:00 | 2022-08-05 00:00:00 |  | 3920 |  |  |  |  |  | False | False | False | False | False | August 2022
[PHONE] | 10 | 10 | SAB | PLASKOLITE LLC | 1 | M50009,MD20,OE8,FR1/8,GI,DR55,STD   * | M/S | 2022-08-05 00:00:00 | 2022-07-29 00:00:00 |  | 4450 |  |  |  |  |  | False | False | False | False | False | July 2022