Spreadsheet: 150579d1334607114-problem-using-solver-with-countif-function-fund-combos
Sheet: Sheet1

 | Weights | 0.1 | 0.1 | 0.2 | 0.3 | 0.3 |  | Sum
 |  |  |  |  |  |  |  | No. Funds
Date |  | Fund A | Fund B | Fund C | Fund D | Fund E | Combo | Benchmark | Outperf
2012-01-01 00:00:00 |  | 0.91948054485599 | 0.9011530720493824 | 0.8637860899872343 | 0.03540639899895448 | 0.7236255427889701 |  | 0.6615735873792291
2012-01-02 00:00:00 |  | 0.1976948580631064 | 0.3854483929154673 | 0.7334920281270007 | 0.3463115125634487 | 0.709014612612325 |  | 0.2159654472101235
2012-01-03 00:00:00 |  | 0.3975569742818595 | 0.4944092204578721 | 0.1774610513822753 | 0.9502633140304039 | 0.2182623084917789 |  | 0.2999616939201799
2012-01-04 00:00:00 |  | 0.0766645600929119 | 0.3359450706635139 | 0.728403915780201 | 0.4995072315691367 | 0.1858857422304453 |  | 0.8173674857544161
2012-01-05 00:00:00 |  | 0.1433859442397488 | 0.4612203700785025 | 0.7472467839464093 | 0.1716688931352182 | 0.943574148288823 |  | 0.1928999763891701
2012-01-06 00:00:00 |  | 0.9756906235408656 | 0.5893594487744654 | 0.242890294219457 | 0.3688377588543815 | 0.4516569959681725 |  | 0.526701475944069
2012-01-07 00:00:00 |  | 0.3261905489995027 | 0.8441723003007501 | 0.8718136154771094 | 0.2722367714271849 | 0.6868802195634863 |  | 0.02588588460444741
2012-01-08 00:00:00 |  | 0.02260860674960319 | 0.6305282964469511 | 0.2742709121565844 | 0.9759718054557542 | 0.7074405996615316 |  | 0.9756216119438742
2012-01-09 00:00:00 |  | 0.169829798547382 | 0.9904111188645612 | 0.8635169145431718 | 0.7687529348534952 | 0.162952240478891 |  | 0.9382195832465031
2012-01-10 00:00:00 |  | 0.4115325872265901 | 0.7070873268819111 | 0.954733572227953 | 0.06590812950709757 | 0.1630472036182328 |  | 0.9653429903457532
2012-01-11 00:00:00 |  | 0.9506392349699052 | 0.5010473210265304 | 0.3489325174257379 | 0.8935335397933124 | 0.6256401972868441 |  | 0.1026102360579894
2012-01-12 00:00:00 |  | 0.1150671070237383 | 0.8126830076460804 | 0.7939025594576764 | 0.2048933330826722 | 0.4707065209918346 |  | 0.6379139836269909
2012-01-13 00:00:00 |  | 0.549554726135912 | 0.74559952883398 | 0.9862820772927777 | 0.8617044650012072 | 0.4107602840476515 |  | 0.778397343870473
2012-01-14 00:00:00 |  | 0.5460528509752252 | 0.9418198532135575 | 0.2634820375154142 | 0.9067868802209509 | 0.3863040940815806 |  | 0.005808372408885543
2012-01-15 00:00:00 |  | 0.01711636044064957 | 0.5991957390246864 | 0.1322019639583114 | 0.02910403279065055 | 0.7125402446159591 |  | 0.5419573011670795
2012-01-16 00:00:00 |  | 0.3191029867762905 | 0.5251584907364656 | 0.05233451162451463 | 0.3119963283643837 | 0.329444322758961 |  | 0.5981089344797503
2012-01-17 00:00:00 |  | 0.08486429082423508 | 0.8923665968223727 | 0.1765482071200107 | 0.535682688185827 | 0.9795577864647811 |  | 0.9725374517483975
2012-01-18 00:00:00 |  | 0.6322748107626359 | 0.1499131548575 | 0.8124601573255651 | 0.2228737210005678 | 0.6999197458106793 |  | 0.1006091732304417
2012-01-19 00:00:00 |  | 0.7070663853212361 | 0.06739273079346686 | 0.5448427018799971 | 0.09013682284244329 | 0.9182005578372835 |  | 0.5588685992564594
2012-01-20 00:00:00 |  | 0.9454725586006206 | 0.6721372286689791 | 0.4501963241933988 | 0.1064713539054378 | 0.1096800645356868 |  | 0.6891840457393837