Spreadsheet: 888036d1738343623-sumifs-excluding-contents-of-specific-cell-01-30-25-sumifs-conditionals-exclude-w-excel-forum-member-help
Sheet: Data Sheet

Table 2
ORDER NUMBER | PRODUCT  ID | [NAME] | QUANTITY | Per UoM | EA Qty | QTY Received | Received | Pending Back Order Qty | EXTERIOR LOCATION
24793 | FLM056 | 406MM/MB70M CHINA | 204 | 575182 | 117337128 | 72 |  | 132
24793 | FLM057 | 422MM/MB70M CHINA | 201 | 597849 | 120167649 | 52 |  | 149
24870 | FLM003 | [NAME] 18.5 | 148 | 104818 | 15513064 | 105 |  | 43
24831 | CHI035S | Tortichips Natural 0.85OZ | 399 | 600 | 239400 |  |  |  | HWKENT
25314 | pbj006 | PBJ Squeeze - Strawberry | 120 | 200 | 24000
25270 | CHE034 | Real American Cheese IWS .67oz | 1296 | 720 | 933120
25332 | DRI001 | Mango Drink Mix | 126 | 3000 | 378000
25332 | DRI002 | Orange Drink Mix | 126 | 3000 | 378000
25332 | DRI004 | Grape Drink Mix | 84 | 3000 | 252000
25332 | DRI005 | Tropical Punch Drink Mix | 168 | 3000 | 504000
25332 | DRI003 | Lemon Drink Mix | 210 | 3000 | 630000
25390 | RB-CON008 | Buttermilk Biscuit Mix | 20 | 1 | 20 |  |  |  | Direct Ship
25390 | RB-CON009 | [NAME] | 24 | 1 | 24 |  |  |  | Direct Ship
25390 | RB-CON010 | [NAME] | 24 | 1 | 24 |  |  |  | Direct Ship
25390 | RB-CON011 | French Dressing | 60 | 1 | 60 |  |  |  | Direct Ship
25390 | RB-CON012 | Italian Dressing | 60 | 1 | 60 |  |  |  | Direct Ship
25390 | RB-CON013 | White Vinegar | 24 | 1 | 24 |  |  |  | Direct Ship
25390 | RB-CON005 | [NAME] | 20 | 1 | 20 |  |  |  | Direct Ship
25390 | RB-CON006 | Pancake Mix | 20 | 1 | 20 |  |  |  | Direct Ship
25390 | RB-CON007 | [NAME] | 20 | 1 | 20 |  |  |  | Direct Ship
24739 | SNK192 | Peanut Butter Crackers | 1900 | 288 | 547200
24736 | SNK136 | [NAME] with  Chocolate Cream | 471 | 288 | 135648
24736 | SNK189 | Chocolate Cookies with Vanilla Cream | 951 | 288 | 273888
24736 | SNK190 | Vanilla Cookies with Strawberry Cream | 446 | 288 | 128448
24736 | SNK191 | Vanilla Cookies with Banana Cream | 532 | 288 | 153216
24737 | SNK136 | [NAME] with  Chocolate Cream | 471 | 288 | 135648
24737 | SNK189 | Chocolate Cookies with Vanilla Cream | 951 | 288 | 273888
24737 | SNK190 | Vanilla Cookies with Strawberry Cream | 446 | 288 | 128448
24737 | SNK191 | Vanilla Cookies with Banana Cream | 532 | 288 | 153216
24713 | SNK136 | [NAME] with  Chocolate Cream | 471 | 288 | 135648
24713 | SNK189 | Chocolate Cookies with Vanilla Cream | 951 | 288 | 273888
24713 | SNK190 | Vanilla Cookies with Strawberry Cream | 446 | 288 | 128448
24713 | SNK191 | Vanilla Cookies with Banana Cream | 532 | 288 | 153216
24735 | SNK136 | [NAME] with  Chocolate Cream | 471 | 288 | 135648
24735 | SNK189 | Chocolate Cookies with Vanilla Cream | 951 | 288 | 273888
24735 | SNK190 | Vanilla Cookies with Strawberry Cream | 446 | 288 | 128448
24735 | SNK191 | Vanilla Cookies with Banana Cream | 532 | 288 | 153216
24833 | CHI035S | Tortichips Natural 0.85OZ | 399 | 600 | 239400 |  |  |  | HWKENT
25432 | RB-CHI002 | Pending - Spec from Brandon - Potato Chip | 72 | 36 | 2592 |  |  |  | FCC Tucson
25015 | CON022 | [NAME] in 1 112 PP | 1680 | 1000 | 1680000
25276 | SNK182 | Sunflower Seeds 400/0.75oz. | 840 | 400 | 336000 |  |  |  | HWKENT
25439 | brd048 | 51% Whole Grain Artisan Roll | 3660 | 1 | 3660
25067 | BOX003 | Box 12 [NAME] | 6000 | 1 | 6000
25067 | BOX005 | Box 30 Green(Picnic pack) | 7200 | 1 | 7200
25067 | BOX006 | Box 31 Blue(picnic Pack) | 3300 | 1 | 3300
25279 | SNK177 | Cheddar [NAME] | 780 | 300 | 234000
25272 | CHI046 | [NAME]oz | 1680 | 400 | 672000 |  |  |  | HWKENT
25422 | RB-SNK141 | [NAME] 1.7oz. | 600 | 96 | 57600 |  |  |  | HWKENT
25021 | SNK018 | [NAME] 72  PP | 1872 | 200 | 374400
25068 | BOX003 | Box 12 [NAME] | 6000 | 1 | 6000
25068 | BOX005 | Box 30 Green(Picnic pack) | 7200 | 1 | 7200
25068 | BOX006 | Box 31 Blue(picnic Pack) | 3300 | 1 | 3300
25460 | RB-CHE002 | #N/A | 125 | 1 | 125 |  |  |  | INDIAN HEAD
25447 | RB-SNK007 | LDM - Snack Crackers 13.7oz | 800 | 12 | 9600 |  |  |  | FM-Reedley
24834 | CHI035S | Tortichips Natural 0.85OZ | 399 | 600 | 239400 |  |  |  | HWKENT
24738 | SNK192 | Peanut Butter Crackers | 1900 | 288 | 547200
24715 | SNK192 | Peanut Butter Crackers | 1900 | 288 | 547200
25273 | CHI046 | [NAME]oz | 1680 | 400 | 672000 |  |  |  | HWKENT
 | CHI046 | [NAME]oz | 1680 | 400 | 672000 |  |  |  | FM-Reedley
 | CHI046 | [NAME]oz | 1680 | 400 | 672000
 | CHI046 | [NAME]oz | 1680 | 400 | 672000 |  |  |  | anything
25411 | CHE034 | Real American Cheese IWS .67oz | 1200 | 720 | 864000
25280 | SNK177 | Cheddar [NAME] | 780 | 300 | 234000
24740 | SNK192 | Peanut Butter Crackers | 1900 | 288 | 547200
25055 | BOX005 | Box 30 Green(Picnic pack) | 7800 | 1 | 7800
25055 | BOX006 | Box 31 Blue(picnic Pack) | 4200 | 1 | 4200
25022 | SNK018 | [NAME] 72  PP | 1872 | 200 | 374400
25069 | BOX003 | Box 12 [NAME] | 6000 | 1 | 6000
25069 | BOX005 | Box 30 Green(Picnic pack) | 7200 | 1 | 7200
25069 | BOX006 | Box 31 Blue(picnic Pack) | 3300 | 1 | 3300
25287 | BOX001 | Box 20 Green | 8400 | 1 | 8400
25287 | BOX002 | Box 21 Blue | 3600 | 1 | 3600
25016 | CON022 | [NAME] in 1 112 PP | 1680 | 1000 | 1680000
25281 | SNK177 | Cheddar [NAME] | 780 | 300 | 234000
25282 | SNK177 | Cheddar [NAME] | 780 | 300 | 234000
25070 | BOX003 | Box 12 [NAME] | 6000 | 1 | 6000
25070 | BOX005 | Box 30 Green(Picnic pack) | 7200 | 1 | 7200
25070 | BOX006 | Box 31 Blue(picnic Pack) | 3300 | 1 | 3300
24835 | CHI035S | Tortichips Natural 0.85OZ | 399 | 600 | 239400 |  |  |  | HWKENT
25023 | SNK018 | [NAME] 72  PP | 1872 | 200 | 374400
25071 | BOX003 | Box 12 [NAME] | 6000 | 1 | 6000
25071 | BOX005 | Box 30 Green(Picnic pack) | 7200 | 1 | 7200
25071 | BOX006 | Box 31 Blue(picnic Pack) | 3300 | 1 | 3300
25058 | BOX005 | Box 30 Green(Picnic pack) | 10800 | 1 | 10800
24836 | CHI035S | Tortichips Natural 0.85OZ | 399 | 600 | 239400 |  |  |  | HWKENT
25274 | CHI046 | [NAME]oz | 1680 | 400 | 672000 |  |  |  | HWKENT
25072 | BOX003 | Box 12 [NAME] | 6000 | 1 | 6000
25072 | BOX005 | Box 30 Green(Picnic pack) | 7200 | 1 | 7200
25072 | BOX006 | Box 31 Blue(picnic Pack) | 3300 | 1 | 3300
25017 | CON022 | [NAME] in 1 112 PP | 1680 | 1000 | 1680000
25024 | SNK018 | [NAME] 72  PP | 1872 | 200 | 374400
25283 | SNK177 | Cheddar [NAME] | 780 | 300 | 234000
25073 | BOX003 | Box 12 [NAME] | 6000 | 1 | 6000
25073 | BOX005 | Box 30 Green(Picnic pack) | 7200 | 1 | 7200
25073 | BOX006 | Box 31 Blue(picnic Pack) | 3300 | 1 | 3300
25060 | BOX005 | Box 30 Green(Picnic pack) | 8400 | 1 | 8400
25060 | BOX006 | Box 31 Blue(picnic Pack) | 3600 | 1 | 3600
25074 | BOX003 | Box 12 [NAME] | 6000 | 1 | 6000
25074 | BOX005 | Box 30 Green(Picnic pack) | 7200 | 1 | 7200
25074 | BOX006 | Box 31 Blue(picnic Pack) | 3300 | 1 | 3300
25284 | SNK177 | Cheddar [NAME] | 780 | 300 | 234000
25056 | BOX005 | Box 30 Green(Picnic pack) | 7800 | 1 | 7800
25056 | BOX006 | Box 31 Blue(picnic Pack) | 4200 | 1 | 4200
25054 | BOX005 | Box 30 Green(Picnic pack) | 7800 | 1 | 7800
25054 | BOX006 | Box 31 Blue(picnic Pack) | 4200 | 1 | 4200
25277 | SNK018 | [NAME] 72  PP | 1872 | 200 | 374400
25057 | BOX005 | Box 30 Green(Picnic pack) | 7800 | 1 | 7800
25057 | BOX006 | Box 31 Blue(picnic Pack) | 4200 | 1 | 4200
25285 | SNK177 | Cheddar [NAME] | 780 | 300 | 234000
25275 | CHI046 | [NAME]oz | 1680 | 400 | 672000 |  |  |  | HWKENT
25059 | BOX005 | Box 30 Green(Picnic pack) | 8400 | 1 | 8400
25059 | BOX006 | Box 31 Blue(picnic Pack) | 3600 | 1 | 3600
25278 | SNK018 | [NAME] 72  PP | 1872 | 200 | 374400
25286 | SNK177 | Cheddar [NAME] | 780 | 300 | 234000