Spreadsheet: 122063d1316595337-sumproduct-problem-book2
Sheet: Sheet1

 | Function | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
Org 1 | Office | 456.1975491914723 | 522.7732283074961 | 535.358159917994 | 569.7535953176473 | 489.7995006277248 | 875.9960244035514 | 297.7578656505175 | 861.5348853104172 | 399.7394767669408 | 851.4461622903534 | 457.9357503396722 | 198.2184851742148
Org 2 | Office | 503.7400114024635 | 42.19090691153848 | 504.2633648511382 | 126.0787819286349 | 41.88213958160348 | 79.75620938052863 | 228.3540245789217 | 635.320650256399 | 634.5721077669976 | 827.8658630902039 | 475.5383283833983 | 173.8829997233845
Org 3 | Office | 537.4890521678731 | 893.8127746611541 | 80.54045347347163 | 460.214584588977 | 199.2099251353101 | 696.3028784048989 | 475.9899091293939 | 522.7547101274498 | 666.3476605348233 | 473.5941712726764 | 276.4234819760283 | 41.00134402543656
Org 4 | GYM | 214.1622029992857 | 795.0930971357656 | 133.41979323055 | 588.4170801298818 | 203.1262053941605 | 520.6935092771819 | 781.3961246009155 | 249.9509596289465 | 818.4896659128798 | 619.1377520530025 | 598.0744185607201 | 513.0335952085403
Org 5 | GYM | 727.7130001456319 | 872.388640969315 | 226.5451125894611 | 184.2159833336883 | 67.67874576775527 | 470.6117561393083 | 837.867122865835 | 199.6280912932002 | 94.97127454559273 | 883.1410093789517 | 74.77364065838579 | 101.1198728692187
Org 6 | GYM | 339.2858268661119 | 418.9845017667528 | 472.9580984067101 | 481.6486686418584 | 326.0524172350835 | 562.8968410428148 | 841.1159508679035 | 267.5266053260009 | 157.9030445463927 | 14.08874615891982 | 184.4571777068622 | 294.4599187821486
Org 7 | Shop | 222.8061095082513 | 777.7571949810822 | 576.3751511998888 | 527.9007918248847 | 802.0223632517423 | 25.56544794336881 | 360.0971329090323 | 198.4988474569694 | 238.1172212677441 | 72.55345993225077 | 667.2743569747447 | 103.7855172477479
Org 8 | Shop | 72.4604104820862 | 677.0615034324277 | 640.160242078437 | 170.45437378813 | 297.2202762841699 | 618.7707950378829 | 296.6585468881869 | 866.882399178402 | 132.6306534089397 | 292.0196771172866 | 718.4278623364642 | 378.1293643335753
Org 9 | Shop | 470.2138231630746 | 491.7665854457118 | 137.5260870999466 | 641.2943434475696 | 845.5412524559922 | 103.1127543332543 | 184.2882585412099 | 481.6123740024323 | 728.0403943717585 | 340.364362013884 | 309.1702866955823 | 891.2079687654743
Org 10 | Shop | 493.2622297290554 | 534.8025597585535 | 553.2954276647077 | 265.2426389612975 | 656.8514513463784 | 806.1691773339743 | 412.2564285154589 | 152.9601388892686 | 64.64133028606992 | 430.5085690612703 | 496.4290852357073 | 450.4553586766829
Org 11 | Shop | 642.29479983568 | 301.581020701766 | 462.6891638183619 | 35.13541451851727 | 299.7977959327353 | 543.3095184975228 | 792.9237000012299 | 509.4715280996008 | 882.9951017135089 | 857.5235823883477 | 285.9711906008033 | 98.94813416715573
Org 12 | Shop | 80.7758184092144 | 881.572275550995 | 141.3219419085415 | 20.10030333690338 | 462.7223929253453 | 873.5661786913477 | 728.0536235030095 | 425.8790141839135 | 220.5333469393915 | 82.26486450789842 | 197.7318925982369 | 265.0828404310412
 |  | Current Month |  | 2012-08-01 00:00:00
Org No. | Function | Market Share
ORG 1 | Office |  |  |  | I would like the calculation to change depenndant on the "Current Month"
ORG 2 | Office |  |  |  | If [NAME] is entered then it will calc the Market Share for Jan and Feb 12
ORG 3 | Office
ORG 4 | GYM
ORG 5 | GYM
ORG 6 | GYM
ORG 7 | Shop
ORG 8 | Shop
ORG 9 | Shop
ORG 10 | Shop
ORG 11 | Shop
ORG 12 | Shop