Spreadsheet: 167631d1342043691-interesting-sumif-problem-book1-jrohman-oeldere-
Sheet: Sheet1

Unit Sales | CROSSLIST | t1 | t2 | COLA | TOTAL
186893413.8938151 | COLA2L |  |  | 2L |  |  | Good problem to fix here.
176509200.0582993 | COLA12p12oz |  |  | 12 pack 12oz
137600879.9984531 | COLA2L |  |  | 20oz |  |  | In Sheet1, Column A shows you unit sale, and column B shows the name that corresponds to that unit sale. Column E shows for the title 'COLA', the 109 different size packages. In column E, I need to create a SUMIF that returns a given package total sale.
111557141.9681086 | COLA12p12oz |  |  | 1L
110940572.8731605 | COLA12p12oz |  |  | 6 pack 16.9 oz |  |  | For instance, F2 will read, =SUMIF(B2,"COLA2L",A2). It will return the proper number.
86067510.12093835 | COLA2L |  |  | 8 pack 12oz
80496677.69861588 | COLA20oz |  |  | 24 pack 12oz |  |  | F3 will read =SUMIF(B3, "COLA12p12oz", [NAME]). This too will return the proper number.
71374609.21154842 | LEMONLIME2L |  |  | 12oz
64505655.5955789 | LEMONLIME20oz |  |  | 1.25L |  |  | What I want to know, is in the SUMIF, can I search for the word 'COLA', then search individually for each package ('2L', '12p12oz', '20oz' etc...)? On Sheet 2, I have a table set up that shows each package corresponded to the proper abbreviation. It might work into some sort of VLOOKUP within the SUMIF.
64069323.59887595 | LEMONLIME2L |  |  | 1.5L
63916137.3557862 | COLA2L |  |  | 20 pack 12oz |  |  | I'd like to do this because I have to do it for 15 different flavors. 15x109=1635 times I'd have to type it in manually every time instead. Catch my drift? If someone can help I can just click and drag.
60606774.87861127 | LEMONLIME12p12oz |  |  | 8 pack 7.5oz
59710566.82116125 | COLA12p12oz |  |  | 6 pack 12oz |  |  | Any help is appreciated.
57696112.74969445 | COLA2L |  |  | 8oz
56039480.47365732 | COLA20oz |  |  | 6 pack 8oz
52535489.39687476 | COLA20oz |  |  | 12.5oz |  |  | jimbo
49822141.56890106 | COLA12p12oz |  |  | 6.76oz |  |  | Rijlabels | Aantal van Unit Sales
49594818.42900008 | LEMONLIME12p12oz |  |  | 8 pack 16.9oz |  |  | COLA1.25L | 3
45968371.4921875 | LEMONLIME2L |  |  | 8.45oz |  |  | COLA1.5L | 2
44965035.40291518 | COLA20oz |  |  | 2.5L |  |  | COLA12oz | 1
41145851.43134264 | GINGER2L |  |  | 16oz |  |  | COLA12p12oz | 26
34318481.1956256 | LEMONLIME20oz |  |  | 24oz |  |  | COLA20oz | 9
31766135.19586902 | COLA20oz |  |  | 16.9oz |  |  | COLA20p12oz | 4
31589877.03628554 | COLA12p12oz |  |  | 18 pack 12oz |  |  | COLA24p12oz | 5
31140522.09419459 | COLA12p12oz |  |  | 6 pack 20oz |  |  | COLA2L | 23
31125326.62648152 | COLA2L |  |  | 11.16oz |  |  | COLA6p16.9oz | 8
30744380.77084067 | LEMONLIME2L |  |  | 4 pack 16oz |  |  | COLA8p12oz | 7
27506426.74628704 | COLA2L |  |  | 11.5oz |  |  | COLA8p7.5oz | 2
27349658.4508826 | COLA6p16.9oz |  |  | 21oz |  |  | CREAM2L | 2
27156143.12963289 | COLA1.25L |  |  | 4 pack 8oz |  |  | GINGER12p12oz | 4
27051938.58126161 | ROOTBEER2L |  |  | 10 pack 7oz |  |  | GINGER1L | 1
25890836.42139501 | COLA2L |  |  | 6 pack 11.27oz |  |  | GINGER20oz | 1
25848760.54573084 | COLA12p12oz |  |  | 4 pack 7oz |  |  | GINGER2L | 5
25296547.94009275 | COLA20p12oz |  |  | 9.6oz |  |  | LEMONLIME1.25L | 1
24570626.52293476 | ORANGE2L |  |  | 10oz |  |  | LEMONLIME1.5L | 1
24370297.32186779 | LEMONLIME12p12oz |  |  | 24 pack 16.9oz |  |  | LEMONLIME12p12oz | 12
24118816.85563156 | COLA8p12oz |  |  | 11.1oz |  |  | LEMONLIME1L | 2
23612180.66590289 | COLA24p12oz |  |  | 8.5oz |  |  | LEMONLIME20oz | 5
23534234.91965454 | COLA2L |  |  | 30 pack 12oz |  |  | LEMONLIME20p12oz | 1
22458934.98304854 | LEMONLIME20oz |  |  | 8.62oz |  |  | LEMONLIME24p12oz | 2
22206910.20227491 | LEMONLIME2L |  |  | 36 pack 12oz |  |  | LEMONLIME2L | 12
21874683.6369541 | COLA12p12oz |  |  | 9.5oz |  |  | LEMONLIME6p16.9oz | 4
21788020.76958051 | COLA6p16.9oz |  |  | 4 pack 20oz |  |  | LEMONLIME8oz | 1
21426732.96434516 | ROOTBEER8oz |  |  | 25.4oz |  |  | LEMONLIME8p12oz | 2
21308815.79699589 | COLA20oz |  |  | 28oz |  |  | LEMONLIME8p7.5oz | 1
21183315.40705642 | LEMONLIME2L |  |  | 13.5oz |  |  | ORANGE1.25L | 1
20958244.38495437 | COLA2L |  |  | 4 pack 16.9oz |  |  | ORANGE12p12oz | 4
20486830.66643703 | COLA12p12oz |  |  | 14oz |  |  | ORANGE20oz | 3
19839450.99595865 | LEMONLIME2L |  |  | 22oz |  |  | ORANGE2L | 4
19569368.67624273 | COLA20oz |  |  | 4 pack 6.8oz |  |  | ORANGE8oz | 1
18471137.45677714 | LEMONLIME12p12oz |  |  | 11.6oz |  |  | PRIVATELABEL1L | 1
17826167.80712068 | LEMONLIME2L |  |  | 4 pack 11.5oz |  |  | PRIVATELABEL2L | 1
16763542.69284938 | COLA1.5L |  |  | 7.57oz |  |  | ROOTBEER12p12oz | 4
16626494.7054693 | LEMONLIME12p12oz |  |  | 7oz |  |  | ROOTBEER20oz | 1
16246079.19231302 | LEMONLIME12p12oz |  |  | 12.7oz |  |  | ROOTBEER2L | 4
15933502.96114643 | GINGER12p12oz |  |  | 4 pack 11.1oz |  |  | ROOTBEER6p16.9oz | 1
15929108.38337596 | GINGER2L |  |  | 4 pack 6.3oz |  |  | ROOTBEER8oz | 1
15396684.84065574 | COLA8p12oz |  |  | 4 pack 9.3oz |  |  | SELTZER1L | 3
15108385.86685426 | COLA2L |  |  | 17.2oz |  |  | TONIC1L | 3
14735858.54516551 | ROOTBEER12p12oz |  |  | 4 pack 11.6oz |  |  | Eindtotaal | 179
14565039.64744564 | COLA2L |  |  | 25oz
14460536.00220761 | ROOTBEER2L |  |  | 6.6oz
14247429.74086359 | LEMONLIME24p12oz |  |  | 15 pack 12oz
14105193.17245186 | GINGER2L |  |  | 24 pack 8oz
14004974.89024213 | COLA12oz |  |  | 3L
13781209.47539829 | ORANGE2L |  |  | KEG!!! (5L)
13421998.86850599 | COLA8p7.5oz |  |  | 4 pack 12.5oz
13396611.06145019 | ORANGE2L |  |  | 9.3oz
13325477.4450262 | COLA12p12oz |  |  | 4 pack 12.7oz
13254350.23081559 | LEMONLIME12p12oz |  |  | 8 pack 7oz
12892645.111545 | ORANGE12p12oz |  |  | 6.7oz
12797372.38914858 | LEMONLIME1.5L |  |  | 28 pack 12oz
12336783.81181296 | TONIC1L |  |  | 11.15oz
12249251.05845543 | LEMONLIME12p12oz |  |  | 4 pack 8.5oz
12210644.97932217 | LEMONLIME2L |  |  | 11.7oz
12140911.22041176 | COLA2L |  |  | 10.14oz
12104389.03305569 | COLA12p12oz |  |  | 6 pack 6.76oz
11898484.40785594 | COLA1.25L |  |  | 12 pack 16.9oz
11895382.45005975 | COLA2L |  |  | 32 pack 12oz
11747321.59893773 | ORANGE2L |  |  | 8 pack 16oz
11383581.99864471 | COLA20p12oz |  |  | 20.25oz
11259687.29899709 | COLA2L |  |  | 4 pack 2L
11242603.63812397 | ORANGE8oz |  |  | 11.83oz
11026155.87488339 | ROOTBEER2L |  |  | 25.36oz
10857509.96961819 | COLA6p16.9oz |  |  | 16.7oz
10823714.89716083 | LEMONLIME12p12oz |  |  | 17oz
10791084.42385861 | LEMONLIME1.25L |  |  | 2.25L
10770878.42608855 | COLA12p12oz |  |  | 4 pack 11.15oz
10601581.80105995 | COLA24p12oz |  |  | 4 pack 6.325oz
10496467.05549448 | COLA12p12oz |  |  | 11oz
10283381.05761779 | ORANGE12p12oz |  |  | 10.1oz
10277153.73816596 | COLA8p12oz |  |  | 6 pack 13.2oz
10098683.22972344 | COLA12p12oz |  |  | 6.8oz
10041085.27400301 | COLA2L |  |  | 11.2oz
10017462.88481175 | LEMONLIME8p12oz |  |  | 13.52oz
9910194.904204845 | TONIC1L |  |  | 15 pack 11.6oz
9908053.36284187 | COLA24p12oz |  |  | 16.2oz
9885443.59560155 | ROOTBEER12p12oz |  |  | 8.4oz
9854668.296630435 | LEMONLIME12p12oz |  |  | 20.29oz
9750415.556195172 | COLA2L |  |  | 4 pack 8.4oz
9534114.788054092 | COLA6p16.9oz |  |  | 48 pack 12oz
9361018.820040481 | SELTZER1L |  |  | 4 pack 6.5oz
9129560.802708523 | GINGER2L |  |  | 6 pack 8.4oz
9104748.73211321 | COLA12p12oz |  |  | KEG!!! (29.34L)
8917326.524165398 | ROOTBEER20oz |  |  | 40 pack 12oz
8907915.645779412 | COLA12p12oz |  |  | 11.27oz
8831028.295307826 | LEMONLIME2L |  |  | 6 pack 11.5oz
8815101.307559464 | ORANGE20oz |  |  | 2 pack 50oz
8689097.772341602 | ROOTBEER12p12oz |  |  | 6 pack 16.83oz
8587450.091377225 | ROOTBEER12p12oz |  |  | 12 pack 16.916oz
8551219.971388314 | COLA12p12oz
8485873.361143142 | LEMONLIME2L
8473245.144567233 | LEMONLIME6p16.9oz
8272878.770459412 | ORANGE12p12oz
8190938.511170128 | COLA12p12oz
8110218.287739882 | ORANGE20oz
8100259.020102264 | COLA2L
8079512.350956465 | COLA6p16.9oz
8033892.111079983 | LEMONLIME20oz
7979425.311113317 | COLA24p12oz
7807303.208194136 | LEMONLIME12p12oz
7762749.674207235 | COLA12p12oz
7683947.682050142 | GINGER12p12oz
7665692.283671382 | COLA6p16.9oz
7638385.254212865 | COLA20oz
7468718.489928069 | LEMONLIME8oz
7319513.728033355 | COLA8p7.5oz
7317274.39946017 | LEMONLIME20oz
7154990.626407948 | ORANGE12p12oz
7015554.897887244 | LEMONLIME2L
6913447.82944458 | COLA6p16.9oz
6832007.610068961 | COLA12p12oz
6823153.001206607 | COLA2L
6777342.030572753 | COLA12p12oz
6726520.065678298 | COLA1.5L
6653949.337726121 | TONIC1L
6622408.885408467 | COLA8p12oz
6542781.814326912 | LEMONLIME1L
6534297.571467976 | LEMONLIME12p12oz
6454794.602631917 | COLA2L
6429417.604191779 | COLA6p16.9oz
6404321.410677536 | COLA2L
6272348.826411308 | COLA8p12oz
6268240.575163109 | COLA12p12oz
6260724.034011069 | COLA8p12oz
6217535.590561944 | LEMONLIME6p16.9oz
6110748.024431983 | ROOTBEER6p16.9oz
6087161.257597038 | LEMONLIME8p7.5oz
5900496.277446562 | GINGER12p12oz
5899722.86969678 | COLA2L
5864953.324679298 | LEMONLIME6p16.9oz
5861069.280341839 | COLA2L
5756709.900405565 | COLA12p12oz
5694161.969937009 | PRIVATELABEL1L
5573270.713611344 | COLA12p12oz
5563054.368383836 | ORANGE20oz
5546018.204680274 | COLA1.25L
5472224.33310105 | LEMONLIME8p12oz
5441367.451717762 | CREAM2L
5435398.478627711 | SELTZER1L
5396817.071996955 | ROOTBEER2L
5324613.445628401 | GINGER12p12oz
5269827.637492922 | COLA12p12oz
5239482.939024135 | COLA20oz
5187529.870967914 | LEMONLIME6p16.9oz
5162397.972795731 | COLA8p12oz
5153400.012894185 | GINGER20oz
5114435.937745115 | LEMONLIME1L
4988341.689252288 | COLA20p12oz
4881722.521028304 | ORANGE1.25L
4881007.893727027 | PRIVATELABEL2L
4872550.502551883 | CREAM2L
4801473.632757112 | GINGER1L
4792228.152043863 | LEMONLIME20p12oz
4744268.550460873 | SELTZER1L
4739379.873639673 | LEMONLIME24p12oz
4716224.671985451 | GINGER2L
4707300.779476983 | COLA24p12oz
4668799.311179387 | COLA20p12oz