Spreadsheet: 864115d1711437896-trying-to-combine-an-min-if___-with-max-if_____-into-1-formula-forum-question-combining-formulas-to-eliminate-columns-aligw
Sheet: With Columns

4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39
Price | LY | LY-1 | LY-2 | LY-3 | LY-4 | LY-5 | LY-6 | LY-7 | [NAME] | [NAME] | LY-10 | LY-11 | Scored by Yearly Negative % Change |  |  |  |  |  |  |  |  |  |  | Scored by Yearly Positive % Change |  |  |  |  |  |  |  |  |  |  | Sum of Score
57.84 | 37.43185523443124 | 31.87323218640234 | 16.75348285522857 | 15.9874539790502 | 16.02201063506296 | 13.13208564240806 | 10.48677857611078 | 9.773694404800445 | 10.78316228211959 | 8.900379375839556 | 4.708968495251687 | 3.759002791884165
3741.88 | 396.6207253558379 | 312.4833365028387 | 240.9925097432795 | 187.2918095106866 | 164.6412505373609 | 144.4020323214039 | 117.0005657920877 | 100.2777463193658 | 86.745422801057 | 78.77236693091733 | 57.13363533408833 | 42.05483201208003
101.47 | 17.45864373280997 | 14.29468614979387 | 12.9570860338935 | 12.06489439648307 | 10.93664242125378 | 9.655760628878385 | 8.300472837078495 | 6.941426824125947 | 5.82680856170034 | 4.790120363410265 | 4.205851208254141 | 3.625452382244902
77.77 | 71.30763123945619 | 59.14303201506591 | 41.40061521758798 | 48.19051010415739 | 52.38135743398901 | 45.39419526930347 | 33.37462843215981 | 30.08732431598889 | 30.50274463660729 | 33.61900830984693 | 32.01629305887588 | 21.24441118870783
1496.48 | 1031.871562940842 | 1018.802557732875 | 939.7254237102944 | 569.9765228056706 | 787.3631138317184 | 600.1549631395393 | 590.5119829994884 | 403.0173684522224 | 426.2573629361124 | 467.8655716038894 | 287.2460344162813 | 393.9489349141536
182.36 | 22.53805149966444 | 19.32981455268821 | 17.11278871310331 | 15.98849963885228 | 15.03238758398389 | 12.11951085647896 | 11.7981650279888 | 10.48062279278374 | 9.668741213529495 | 8.640469680211103 | 7.471371289504792 | 6.399781952509548
216.54 | 87.54908739581879 | 98.6178491495076 | 77.59396694392504 | 42.43077889870165 | 47.54302646913493 | 42.7604539809572 | 41.66248491274394 | 31.95780854328338 | 28.98055045776377 | 32.18033673616686 | 31.54237406664416 | 33.31245945267537
115.7 | 58.25485846067983 | 50.86337241844665 | 41.00462955061415 | 42.25216047567245 | 43.27460019336189 | 37.635852750776 | 45.09195584193829 | 40.18581433548765 | 30.56234764275435 | 27.04631631878168 | 24.17467118475746 | 20.57731988326237
231.47 | 31.14702323824797 | 28.01988788888466 | 23.5533873892502 | 20.69226121194052 | 20.42770381058281 | 18.67224776967132 | 17.56083965917085 | 14.65695354006972 | 11.49690116076246 | 11.15893254177038 | 10.40363208954914 | 9.141896257536049
124.13 | 47.19278222469201 | 32.27884564934899 | 27.424357960937 | 30.57237892393972 | 26.74717337453707 | 25.77424376190697 | 23.4877375159666 | 23.47858810623604 | 21.19624518572423 | 20.86329044699849 | 22.13392289246314 | 19.10604731177449
176.29 | 25.58613349551467 | 24.92278554778555 | 20.4333098094566 | 19.42780823843666 | 20.71517844743786 | 19.49761742682097 | 17.30493630573248 | 15.51159793814433 | 15.74996877731984 | 14.79936577631418 | 12.54299608587356 | 11.38659320477502
10.86 | 21.02335389040347 | 19.93259398463072 | 16.7745692279188 | 13.07738457602146 | 13.10994062271159 | 12.84613959397581 | 11.24074711274627 | 10.21007031753174 | 10.33711830461519 | 9.287913677950998 | 8.144658249737523 | 8.154451532075205
62.97 | 66.2864279766861 | 58.70445344129555 | 44.47277032359905 | 44.52439969016267 | 44.94885496183206 | 47.58393113342898 | 42.70090845562544 | 42.42947813822285 | 36.19512195121951 | 31.56558295964125 | 31.60359869138495 | 31.19463087248322
218.81 | 125.3632236095346 | 120.4498861047836 | 107.6477832512315 | 87.14685314685315 | 81.35483870967742 | 76.14224137931035 | 70.06010518407213 | 64.87042732370753 | 61.20152091254753 | 60.38022813688213 | 55.67220543806646 | 54.09399057975406
68.36 | 26.55555555555556 | 25.97831526271893 | 25.46375617792422 | 25.81848184818482 | 24.7430441898527 | 23.26133553173949 | 22.23441396508728 | 21.54152823920266 | 19.54049586776859 | 19.09060955518946 | 17.29121338912134 | 17.61959399823478
35.22 | 4.292932037385316 | 4.006039914199853 | 3.496352662800369 | 3.066354877462596 | 2.879461012288811 | 2.937353081793312 | 2.419795307528888 | 2.717144522793254 | 2.63866832261198 | 2.644843822949368 | 2.592450753798079 | 2.798457513024587
53.43 | 23.68291178285009 | 23.07354784788968 | 20.06370779358675 | 19.22332185886403 | 20.10760073260074 | 19.75512126206734 | 19.97833935018051 | 22.13661379087083 | 24.14572864321608 | 23.94060283687943 | 19.98518518518518 | 19.23157894736842
55.02 | 14.59126213592233 | 15.05226130653266 | 13.7584789311408 | 13.82872340425532 | 14.26803013993541 | 15.16518847006652 | 15.42316513761468 | 16.47562582345191 | 15.94758065802224 | 14.38559322033898 | 12.44271570014144 | 11.35744680851064
48.78 | 21.23005836575875 | 26.32543209876543 | 23.26791893227879 | 19.35 | 24.82350024789291 | 26.90139211136891 | 29.10032786885246 | 37.93633369923161 | 39.89846517119244 | 45.40530759951749 | 40.84119106699752 | 32.77979274611399
40.34 | 13.08538248437877 | 12.96666666666667 | 12.08032146048073 | 12.20244760443499 | 10.86450661374074 | 10.32301000440667 | 10.06236337003003 | 11.01176470588235 | 13.17420757831561 | 13.70341482484303 | 10.20840336134454 | 57359.15563477599