Spreadsheet: 682788d1592331517-sum-a-row-of-numbers-based-on-conditions-06-15-20-sum-date-conditional
Sheet: Raw Plant B Component Demand

Sum of Pull Quantity |  |  |  | Load Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-06-15 00:00:00
Item Category Code | Item No_ | Description | Packing Text | 06-01-2020 | 06-02-2020 | 06-03-2020 | 06-04-2020 | 06-05-2020 | 06-06-2020 | 06-07-2020 | 06-08-2020 | 06-09-2020 | 06-10-2020 | 06-11-2020 | 06-12-2020 | 06-13-2020 | 06-14-2020 | 06-15-2020 | 06-16-2020 | 06-17-2020 | 06-18-2020 | 06-19-2020 | 06-21-2020 | 06-22-2020 | 06-23-2020 | 06-24-2020 | 06-27-2020 | 06-28-2020 | 06-29-2020 | 06-30-2020 | Grand Total | Column1
BEVERAGE | DRI042 | 07202CP Orange Drink Mix | 2000/1G | 3.72 | 3.52 | 3.3 | 10.2 | 24.26799999999999 | 20.16 | 31.56 | 32.66 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | boxes
 | DRI044 | 07203CP Grape Drink Mix | 2000/1G | 0 | 2.24 | 2.85623 | 8.576 | 16.772 | 12.6 | 13.92 | 27.93999999999999
 | DRI043 | 07204P Lemon Drink MIx | 2000/1G | 0 | 0.9 | 0 | 12.68 | 6.199999999999999 | 0 | 14.04 | 8.64 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DRI043
BOXES-RM | BOX001 | Box 20 Green | 1/300 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0
 | BOX002 | Box 21 Blue | 1/300 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0
 | BOX005 | Box 30 Green(Picnic pack) | 1/300 | 131 | 235 | 283 | 1116 | 1681 | 1147 | 2097 | 2433
 | BOX006 | Box 31 Blue(picnic Pack) | 1/300 | 56 | 101 | 122 | 480 | 728 | 492 | 908 | 1052
 | BOX013 | Small Klick Lock | 1/800 | 7440 | 13320 | 12313 | 62912 | 94480 | 65520 | 119040 | 138480
 | BOX033 | Picnic Tray/Beers | 30CS /pallet | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CHIPS | CHI035 | CORN CHIPS 1 OZ | 1/100 | 0 | 0 | 0 | 32.8 | 5.76 | 0 | 0 | 0
 | CHI039 | Pretzel, Plain 600/0.5 oz | 1/600 | 0 | 0 | 0 | 0 | 1.81696 | 0 | 0 | 4.2084
 | CHI040 | Pretzel, Plain 325/1oz 897158 | 1/325 | 0 | 0 | 21.978 | 37.962 | 14.1192 | 0 | 76.05720000000001 | 38.8944
CONDIMENT | CON010 | Winston Brand Salad Dressing | 200/cs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Americana Mustard | 500/5.5GM | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
 | CON022 | [NAME] in 1 | 1000/5.5G | 7.44 | 8.84 | 24.62492 | 49.71199999999999 | 68.032 | 65.52 | 101.24 | 118.52
 | CON011 | Relish 500/9gram | 1/500 | 0 | 0 | 0 | 4.864 | 0 | 0 | 0 | 0
FILMS | FLM003 | [NAME] 18.5 | 1/70# | 0 | 0 | 148005 | 72600 | 24640 | 0 | 277200 | 0
 | FLM058 | Printed Film 18.5" CHINA | 1/45# | 81840 | 146520 | 0 | 619432 | 1014640 | 720720 | 1032240 | 1523280
 | FLM061 | [NAME] 13" | 1/48 | 0 | 0 | 0 | 0 | 99.39599999999999 | 0 | 113.3352 | 253.2815999999999
 | FLM002 | 15" film x 70 ga. | 1/55# | 0 | 41448 | 0 | 348415 | 305630 | 432432 | 308207 | 69696
PBJ | PBJ006 | PBJ Squeeze - Strawberry | 1/200 | 0 | 0 | 0 | 0 | 2.72 | 0 | 0 | 0
 | PBJ007 | PBJ Squeeze - Grape | 1/200 | 0 | 0 | 0 | 33 | 0 | 0 | 50.4 | 12.6
SNACKS | SNK018 | [NAME] 72  PP | 1/200 | 0 | 22.4 | 0 | 140.16 | 148.8 | 126 | 252.8 | 266.6
 | SNK036 | 92000 - Vanilla Sand Cookies | 312/4PC | 0 | 0 | 0 | 10.51282 | 0 | 0 | 0 | 0
 | SNK037 | 92001 - Chocolate Sand Cookies | 312/4PC | 0 | 0 | 21.15385 | 0 | 3.58974 | 0 | 48.58974 | 0
 | SNK039 | [NAME] | 312/4PC | 0 | 0 | 18.3109 | 21.15385 | 3.58974 | 0 | 32.17949 | 0
 |  | [NAME]  200/.75oz |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | SNK067 | Cheese Cracker w/Peanut Butter | 1/144 | 0 | 12.492 | 0 | 116.592 | 322.40464 | 349.776 | 221.5248 | 562.6952
 | SNK081 | Sunflower Seeds 200/1oz. |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SNK117 | Cheddar [NAME] | 100/.50oz. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SNK137 | Soy Nuts Roasted Salted 897079 | 1/600 .5 oz | 12.4248 | 0 | 0 | 8.016 | 38.81079999999999 | 67.3344 | 23.046 | 18.7708
 | SNK109 | Banana Chips 325/1 oz 897193 | 1/325 | 0 | 13.7984 | 0 | 57.5344 | 89.93599999999998 | 0 | 93.016 | 103.2416
 | SNK113 | Cheese Cracker W/Cheese 100 PP |  | 51.6336 | 48.8576 | 39.64447 | 16.656 | 123.2544 | 104.9328 | 114.0936 | 207.0896
 | SNK152 | Tropical Mix 325/.75oz 90808 | 325/.75 OZ | 0 | 0 | 0 |  | 0 | 0 | 108.5392 | 0
 | SNK151 | SUNFLOWER, SLTD 325/1OZ 897564 | 325/1 OZ | 0 | 0 | 0 | 17.248 | 6.5296 | 0 | 7.6384 | 23.408
 | SNK150 | Goldfish Pretzel 0.75OZ 14396C | 300/.75oz. | 0 | 29.4372 | 19.02249 | 31.0356 | 107.4924 | 0 | 81.6516 | 162.1044
CEREAL | CER030 | Honey Toasted 235/1.7 OZ | 235/1.7 OZ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CER031 | Corn 235/1.7 OZ | 235/1.7 OZ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CER032 | Rice 235/1.7 OZ | 235/1.7 OZ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CER033 | FRUIT 235/1.7 OZ | 235/1.7 OZ | 0 | 0 | 0 | 42.0888 | 0 | 0 | 64.4112 | 0
[NAME] | LAB003 | Label 4" x3" Thermal | 1/2000 ea | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0
 | LAB004 | Ribbon,LXT 4.33"x1,476' | 1/1476' | 0.06981 | 0.1252 | 0.15132 | 0.59808 | 0.8955299999999996 | 0.6144499999999999 | 1.1188 | 1.3011
 | LAB022 | Label 4" x6" Thermal Transfer | 1/1000 | 186 | 333 | 404 | 1590 | 2376 | 1638 | 2976 | 3462
 | LAB001 | TT Ribbon Black 110mm x 700M | 700m per roll | 51.25 | 92 | 164.75 | 434.5 | 641.75 | 450.5 | 820.5 | 948.5