Spreadsheet: 109092d1305998185-help-with-a-formula-that-utilizes-a-drop-down-list-book1
Sheet: data

 | One | Two | Three | Four | Five | Six | Seven | Eight | Nine | Ten | Eleven | Twelve | Total
AA |  | 562 | 71 | 62 | 279 | 8516 | 1053 | 292 | 2516 | 14985 | 3690 | 3241 | 35267
AB |  | 2 | 0 | 0 | 2 | 5 | 0 | 0 | 0 | 10 | 13 | 20 | 52
AC |  | 1349 | 288 | 395 | 520 | 33134 | 16633 | 3601 | 25081 | 56124 | 11167 | 12938 | 161230
AD |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AE |  | 5 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 3 | 3 | 0 | 15
AF |  | 13 | 0 | 3 | 22 | 49 | 11 | 15 | 2 | 50 | 82 | 51 | 298
AH |  | 63 | 15 | 8 | 64 | 1101 | 852 | 74 | 320 | 2160 | 612 | 429 | 5698
AI |  | 50 | 12 | 5 | 59 | 322 | 126 | 1 | 5 | 1911 | 538 | 235 | 3264
AJ |  | 614 | 72 | 57 | 256 | 7493 | 1039 | 131 | 883 | 12864 | 2508 | 3151 | 29068
AK |  | 919 | 134 | 9 | 258 | 2466 | 40 | 42 | 25 | 2635 | 496 | 334 | 7358
AL |  | 580 | 169 | 90 | 214 | 9875 | 2705 | 345 | 3409 | 16026 | 2925 | 3345 | 39683
AM |  | 4 | 1 | 0 | 1 | 59 | 2 | 0 | 1 | 33 | 6 | 12 | 119
Total |  | 4161 | 762 | 629 | 1677 | 63023 | 22461 | 4501 | 32242 | 106801 | 22040 | 23756 | 282053
Check |  | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1
WEEK 1
 |  | One | Two | Three | Four | Five | Six | Seven | Eight | Nine | Ten | Eleven | Total |  |  | NUMBERS
AA |  | 0.1350636866137948 | 0.09317585301837271 | 0.0985691573926868 | 0.1663685152057245 | 0.1351252717261952 | 0.04688126085214372 | 0.06487447233948011 | 0.07803486136095776 | 0.1403076750217695 | 0.1674228675136116 | 0.1364286916989392 | 0.1250367838668619 |  |  | One
AB |  | 0.0004806536890170632 | 0 | 0 | 0.001192605843768634 | 7.933611538644622e-05 | 0 | 0 | 0 | 9.363208209660958e-05 | 0.0005898366606170599 | 0.0008418925745074928 | 0.0001843625134283273 |  |  | Two
AC |  | 0.3242009132420091 | 0.3779527559055118 | 0.6279809220985691 | 0.310077519379845 | 0.5257445694429018 | 0.7405280263567963 | 0.8000444345700956 | 0.7778983933999132 | 0.5255006975590116 | 0.5066696914700545 | 0.5446203064488971 | 0.5716301546163309 |  |  | Three
AD |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | Four
AE |  | 0.001201634222542658 | 0 | 0 | 0.001192605843768634 | 3.173444615457849e-05 | 0 | 0 | 0 | 2.808962462898287e-05 | 0.0001361161524500908 | 0 | 5.318149425817134e-05 |  |  | Five
AF |  | 0.003124248978610911 | 0 | 0.004769475357710651 | 0.01311866428145498 | 0.0007774939307871729 | 0.0004897377676862117 | 0.003332592757165074 | 6.203089138390919e-05 | 0.0004681604104830479 | 0.003720508166969147 | 0.002146826064994107 | 0.001056539019262337 |  |  | Six
AG |  | 0.01514059120403749 | 0.01968503937007874 | 0.01271860095389507 | 0.0381633870005963 | 0.01746981260809546 | 0.0379324161880593 | 0.0164407909353477 | 0.00992494262142547 | 0.02022452973286767 | 0.02776769509981851 | 0.01805859572318572 | 0.02020187695220402 |  |  | Seven
AH |  | 0.01201634222542658 | 0.01574803149606299 | 0.00794912559618442 | 0.03518187239117471 | 0.005109245830887136 | 0.005609723520769334 | 0.0002221728504776716 | 0.000155077228459773 | 0.01789309088866209 | 0.02441016333938294 | 0.00989223775046304 | 0.01157229315057808 |  |  | Eight
AI |  | 0.1475606825282384 | 0.09448818897637795 | 0.09062003179650238 | 0.1526535480023852 | 0.1188931025181283 | 0.0462579582387249 | 0.02910464341257498 | 0.02738663854599591 | 0.1204483104090786 | 0.1137931034482759 | 0.1326401751136555 | 0.103058645006435 |  |  | Nine
AJ |  | 0.2208603701033405 | 0.1758530183727034 | 0.01430842607313196 | 0.1538461538461539 | 0.03912857210859527 | 0.001780864609768042 | 0.00933125972006221 | 0.0007753861422988648 | 0.02467205363245662 | 0.02250453720508167 | 0.01405960599427513 | 0.02608729565010831 |  |  | Ten
AK |  | 0.1393895698149483 | 0.2217847769028871 | 0.1430842607313196 | 0.1276088252832439 | 0.1566888278882313 | 0.1204309692355639 | 0.0766496334147967 | 0.1057316543638732 | 0.1500547747680265 | 0.1327132486388385 | 0.1408065330863782 | 0.1406934157764675 |  |  | Eleven
AL |  | 0.0009613073780341264 | 0.001312335958005249 | 0 | 0.0005963029218843172 | 0.0009361661615600653 | 8.904323048840212e-05 | 0 | 3.10154456919546e-05 | 0.0003089858709188116 | 0.0002722323049001815 | 0.0005051355447044957 | 0.0004219065211148259 |  |  | Total
Total |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
WEEK 2
 |  | One | Two | Three | Four | Five | Six | Seven | Eight | Nine | Ten | Eleven | Total
AA |  |  |  |  |  |  |  |  |  |  |  |  | 0.1250367838668619
AB |  |  |  |  |  |  |  |  |  |  |  |  | 0.0001843625134283273
AC |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.5716301546163309
AD |  |  |  |  |  |  |  |  |  |  |  |  | 0
AE |  |  |  |  |  |  |  |  |  |  |  |  | 5.318149425817134e-05
AF |  |  |  |  | 0.07 |  |  |  |  |  |  |  | 0.001056539019262337
AG |  |  |  |  | 0.083 |  |  |  |  |  |  |  | 0.02020187695220402
AH |  |  |  |  |  | 0.062 |  |  |  |  |  |  | 0.01157229315057808
AI |  | 0.102 | 0.14 | 0.148 | 0.102 | 0.104 | 0.102 | 0.102 | 0.102 | 0.102 | 0.102 | 0.102 | 0.103058645006435
AJ |  | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.1 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02608729565010831
AK |  | 0.11 | 0.11 | 0.11 | 0.02 | 0.11 | 0.107 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.1406934157764675
AL |  |  |  |  |  |  |  |  |  |  |  |  | 0.0004219065211148259
Total