Spreadsheet: 124308d1318326288-sumproduct-help-please-sumproduct-help
Sheet: Sheet2

Group | Stage | 20110706 | 20110707 | 20110708 | 20110709 | 20110710 | 20110711 | 20110712 | 20110713 | 20110714 | 20110715 | 20110716 | 20110717 | 20110718 | 20110719 | 20110720 | 20110721 | 20110722 | 20110723 | 20110724 | 20110725 | 20110726 | 20110727 | 20110728 | 20110729 | 20110730 | 20110731 | 20110801 | 20110802 | 20110803 | 20110804 | 20110805 | 20110806 | 20110807 | 20110808 | 20110809 | 20110810 | 20110811 | 20110812 | 20110813 | 20110814 | 20110815 | 20110816 | 20110817 | 20110818 | 20110819 | 20110820 | 20110821 | 20110822 | 20110823 | 20110824 | 20110825 | 20110826 | 20110827 | 20110828 | 20110829 | 20110830 | 20110831 | 20110901 | 20110902 | 20110903 | 20110904 | 20110905 | 20110906 | 20110907 | 20110908 | 20110909 | 20110910 | 20110911 | 20110912 | 20110913 | 20110914 | 20110915 | 20110916 | 20110917 | 20110918 | 20110919 | 20110920 | 20110921 | 20110922 | 20110923 | 20110924 | 20110925 | 20110926 | 20110927 | 20110928 | 20110929 | 20110930 | 20111001 | 20111002 | 20111003
Alpha | A | 13 | 1 |  | 0 | 3 | 5 | 18 | 5 | 16 | 20 | 21 | 33 | 25 | 13 | 32 |  |  | 0 |  |  | 14 | 1 |  | 5 | 3 |  | 1 |  |  |  |  |  |  | 0 |  | 2 | 1 | 11 | 5 | 2 | 14 |  |  |  |  |  |  |  | 0 |  |  | 1 | 15 |  |  |  |  |  |  |  |  | 4 | 7 |  | 13 | 10 | 2 | 1 | 12 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 9 |  |  | 15 | 87 | 22
Alpha | B |  | 22 |  | 26 | 21 | 7 | 23 | 44 | 26 | 53 | 21 | 26 | 73 | 34 | 86 | 126 | 55 | 71 | 66 | 160 | 115 | 174 | 57 | 12 | 35 | 39 | 20 | 3 | 19 | 5 | 9 | 12 | 67 | 62 | 111 | 76 | 51 | 46 | 29 | 30 | 60 | 55 | 40 | 114 | 34 | 6 | 29 | 13 | 18 | 18 | 6 | 18 | 24 | 16 | 9 | 15 | 4 | 11 | 4 | 13 | 36 | 80 | 78 | 74 | 53 | 22 | 13 | 14 | 16 | 62 | 13 | 91 | 34 | 15 | 49 | 46 | 55 | 114 | 1 | 18 |  | 3 | 3 | 2 | 1 | 48 | 78 | 56 | 1 | 85
Bravo | C | 158 | 137 | 155 | 126 | 180 | 138 | 196 | 134 | 68 | 245 | 202 | 197 | 194 | 125 | 128 | 147 | 118 | 58 | 109 | 71 | 69 | 112 | 114 | 84 | 166 | 59 | 117 | 25 | 96 | 27 | 75 | 54 | 56 | 67 | 162 | 107 | 146 | 115 | 112 | 188 | 216 | 265 | 359 | 99 | 273 | 388 | 295 | 334 | 114 | 199 | 206 | 207 | 38 | 68 | 114 | 164 | 164 | 193 | 180 | 97 | 143 | 260 | 181 | 395 | 287 | 292 | 190 | 115 | 135 | 224 | 226 | 130 | 154 | 139 | 242 | 185 | 178 | 186 | 246 | 159 | 155 | 36 | 159 | 129 | 123 | 164 | 16 | 358 | 87 | 68
Bravo | D | 90 | 55 | 10 | 58 | 91 | 53 | 39 | 23 | 29 | 15 | 30 | 70 | 65 | 24 | 79 | 149 | 47 | 13 | 88 | 7 | 52 | 57 | 60 | 26 | 59 | 28 | 18 | 48 | 35 | 55 | 28 | 30 | 36 | 115 | 104 | 22 | 55 | 29 | 20 | 34 | 10 | 25 | 11 | 20 | 28 | 19 | 17 | 106 | 77 | 43 | 38 | 22 | 27 | 54 | 23 | 52 | 54 | 57 | 30 | 5 | 28 | 49 | 62 | 53 | 88 | 64 | 17 | 42 | 54 | 79 | 96 | 167 | 45 | 63 | 14 | 29 | 99 | 88 | 81 | 38 | 33 | 57 | 85 | 47 | 73 | 29 | 9 | 23 | 23 | 79
 |  | Start Date | Start Date
MARKET SHARE |  | 20110920 | 20110927 |  | [NAME]:
Alpha | A |  |  |  | I need the market share to be calculated on 7 days data starting from the start date
Alpha | B |  |  |  | So 20110920 - 20110926
Bravo | C |  |  |  | and 20110927 - 20111003
Bravo | D |  |  |  | The data will change weekly but with the same paramiters only start dates will change.