Spreadsheet: 811661d1672734484-formula-for-averaging-a-range-of-cells-according-to-subject-by-table-name-test-5
Sheet: 2017-2018

Name | Group | Subject 1 | Subject 2 | Subject 3 | Subject 4 | Subject 5 | Subject 6 | Subject 7 | Subject 8
Name 1 | 1 |  |  | 52 | 76
Name 2 | 1 |  |  | 56 | 76
Name 3 | 1 |  |  | 76 | 76
Name 4 | 1 |  |  | 52 | 40
Name 5 | 1 |  |  | 36 | 20
Name 6 | 1 |  |  | 20 | 12
Name 7 | 1 |  |  | 68 | 88
Name 8 | 1 |  |  | 52 | 52
Name 9 | 1 |  |  | 56 | 60
Name 10 | 1 |  |  | 36 | 12
Name 11 | 1 |  |  | 12 | 16
Name 12 | 1 |  |  | 68 | 44
Name 13 | 1 |  |  | 56 | 72
Name 14 | 1 |  |  | 52 | 56
Name 15 | 1 |  |  | 52 | 60
Name 16 | 1 |  |  | 40 | 36
Name 17 | 1 |  |  | 68 | 48
Name 18 | 1 |  |  | 28 | 24
Name 19 | 1 |  |  | 48 | 68
Name 20 | 1 |  |  | 24 | 8
Name 21 | 1 |  |  | 72 | 100
Name 22 | 1 |  |  | 40 | 73
Name 23 | 1 |  |  | 64 | 100
Name 24 | 1 |  |  | 24 | 60
Name 25 | 1 |  |  | 80 | 100
Name 26 | 1 |  |  | 64 | 53
Name 27 | 1 |  |  | 48 | 80
Name 28 | 1 |  |  | 48 | 80
Name 29 | 1 |  |  | 32 | 87
Name 30 | 1 |  |  | 36 | 36
Name 31 | 1 |  |  | 68 | 87
Name 32 | 1 |  |  | 68 | 93
Name 33 | 1 |  |  | 28 | 67
Name 34 | 1 |  |  | 84 | 100
Name 35 | 1 |  |  | 48 | 100
Name 36 | 1 |  |  | 16 | 0
Name 37 | 1 |  |  | 48 | 93
Name 38 | 1 |  |  | 32 | 67
Name 39 | 1 |  |  | 60 | 93
Name 40 | 1 |  |  | 56 | 100
Name 41 | 1 |  |  | 48 | 87
Name 42 | 1 |  |  | 64 | 100
Name 43 | 1 |  |  | 16 | 80
Name 44 | 1 |  |  | 88 | 87
Name 45 | 1 |  |  | 52 | 87
Name 46 | 1 |  |  | 48 | 73
Name 47 | 1 |  |  | 60 | 80
Name 48 | 1 |  |  | 40 | 93
Name 49 | 1 |  |  | 32 | 80
Name 50 | 1 |  |  | 64 | 87
Name 51 | 1 |  |  | 44 | 73
Name 52 | 1 |  |  | 48 | 87
Name 53 | 1 |  |  | 36 | 87
Name 54 | 1 |  |  | 76 | 100
Name 55 | 1 |  |  | 40 | 80
Name 56 | 1 |  |  | 48 | 80
Name 57 | 1 |  |  | 48 | 60
Name 58 | 2 |  |  | 48 | 36
Name 59 | 2 |  |  | 48 | 8
Name 60 | 2 |  |  | 60 | 52
Name 61 | 2 |  |  | 60 | 56
Name 62 | 2 |  |  | 58 | 64
Name 63 | 2 |  |  | 32 | 28
Name 64 | 2 |  |  | 36 | 60
Name 65 | 2 |  |  | 40 | 40
Name 66 | 2 |  |  | 58 | 56
Name 67 | 2 |  |  | 52 | 52
Name 68 | 2 |  |  | 60 | 28
Name 69 | 2 |  |  | 84 | 80
Name 70 | 2 |  |  | 40 | 48
Name 71 | 2 |  |  | 52 | 76
Name 72 | 2 |  |  | 72 | 52
Name 73 | 2 |  |  | 70 | 80
Name 74 | 2 |  |  | 48 | 52
Name 75 | 2 |  |  | 68 | 56
Name 76 | 2 |  |  | 52 | 52
Name 77 | 2 |  |  | 64 | 80
Name 78 | 2 |  |  | 40 | 48
Name 79 | 2 |  |  | 64 | 84
Name 80 | 2 |  |  | 64 | 84
Name 81 | 2 |  |  | 48 | 64
Name 82 | 2 |  |  | 52 | 64
Name 83 | 2 |  |  | 56 | 56
Name 84 | 2 |  |  | 36 | 64
Name 85 | 2 |  |  | 56 | 60
Name 86 | 2 |  |  | 48 | 44
Name 87 | 2 |  |  | 80 | 84
Name 88 | 2 |  |  | 64 | 80
Name 89 | 2 |  |  | 80 | 80
Name 90 | 2 |  |  | 68 | 68
Name 91 | 2 |  |  | 60 | 56
Name 92 | 2 |  |  | 52 | 64
Name 93 | 2 |  |  | 56 | 88
Name 94 | 2 |  |  | 52 | 84
Name 95 | 2 |  |  | 56 | 72
Name 96 | 2 |  |  | 32 | 24
Name 97 | 2 |  |  | 40 | 32
Name 98 | 2 |  |  | 40 | 36
Name 99 | 2 |  |  | 52 | 52
Name 100 | 2 |  |  | 44 | 40
Name 101 | 2 |  |  | 36 | 48
Name 102 | 2 |  |  | 32 | 72
Name 103 | 2 |  |  | 32 | 36
Name 104 | 2 |  |  | 40 | 64
Name 105 | 2 |  |  | 28 | 32
Name 106 | 2 |  |  | 52 | 52
Name 107 | 2 |  |  | 64 | 68
Name 108 | 2 |  |  | 28 | 48
Name 109 | 2 |  |  | 44 | 44
Name 110 | 2 |  |  | 60 | 72
Name 111 | 2 |  |  | 44 | 36
Name 112 | 2 |  |  | 36 | 52
Name 113 | 2 |  |  | 48 | 52
Name 114 | 2 |  |  | 64 | 56
Name 115 | 2 |  |  | 44 | 60
Name 116 | 2 |  |  | 40 | 21
Name 117 | 3 |  |  | 60 | 36
Name 118 | 3 |  |  | 80 | 60
Name 119 | 3 |  |  | 48 | 48
Name 120 | 3 |  |  | 80 | 64
Name 121 | 3 |  |  | 68 | 52
Name 122 | 3 |  |  | 88 | 72
Name 123 | 3 |  |  | 84 | 64
Name 124 | 3 |  |  | 68 | 60
Name 125 | 3 |  |  | 72 | 64
Name 126 | 3 |  |  | 48 | 44
Name 127 | 3 |  |  | 64 | 52
Name 128 | 3 |  |  | 56 | 56
Name 129 | 3 |  |  | 48 | 52
Name 130 | 3 |  |  | 44 | 52
Name 131 | 3 |  |  | 88 | 64
Name 132 | 3 |  |  | 88 | 48
Name 133 | 3 |  |  | 48 | 32
Name 134 | 3 |  |  | 44 | 48
Name 135 | 3 |  |  | 56 | 60
Name 136 | 3 |  |  | 68 | 44
Name 137 | 3 |  |  | 80 | 32
Name 138 | 3 |  |  | 64 | 48
Name 139 | 3 |  |  | 80 | 64
Name 140 | 3 |  |  | 28 | 24
Name 141 | 3 |  |  | 64 | 60
Name 142 | 3 |  |  | 76 | 76
Name 143 | 3 |  |  | 92 | 56
Name 144 | 3 |  |  | 60 | 24
Name 145 | 3 |  |  | 44 | 28
Name 146 | 3 |  |  | 76 | 40
Name 147 | 3 |  |  | 64 | 40
Name 148 | 3 |  |  | 88 | 72
Name 149 | 3 |  |  | 36 | 16
Name 150 | 3 |  |  | 52 | 56
Name 151 | 3 |  |  | 60 | 60
Name 152 | 3 |  |  | 68 | 56
Name 153 | 3 |  |  | 88 | 68
Name 154 | 3 |  |  | 76 | 52
Name 155 | 3 |  |  | 76 | 52
Name 156 | 3 |  |  | 68 | 44
Name 157 | 3 |  |  | 80 | 48
Name 158 | 3 |  |  | 68 | 52
Name 159 | 3 |  |  | 52 | 24
Name 160 | 3 |  |  | 80 | 68
Name 161 | 3 |  |  | 56 | 24
Name 162 | 3 |  |  | 80 | 48
Name 163 | 3 |  |  | 76 | 52
Name 164 | 3 |  |  | 64 | 44
Name 165 | 3 |  |  | 76 | 52
Name 166 | 3 |  |  | 88 | 68
Name 167 | 3 |  |  | 64 | 48
Name 168 | 3 |  |  | 52 | 64
Name 169 | 3 |  |  | 80 | 64
Name 170 | 3 |  |  | 76 | 56
Name 171 | 3 |  |  | 76 | 56
Name 172 | 3 |  |  | 68 | 56
Name 173 | 3 |  |  | 76 | 52
Name 174 | 4 |  |  | 84 | 68
Name 175 | 4 |  |  | 84 | 66
Name 176 | 4 |  |  | 84 | 58
Name 177 | 4 |  |  | 84 | 76
Name 178 | 4 |  |  | 84 | 68
Name 179 | 4 |  |  | 68 | 62
Name 180 | 4 |  |  | 64 | 74
Name 181 | 4 |  |  | 52 | 48
Name 182 | 4 |  |  | 64 | 64
Name 183 | 4 |  |  | 84 | 70
Name 184 | 4 |  |  | 88 | 74
Name 185 | 4 |  |  | 56 | 52
Name 186 | 4 |  |  | 60 | 26
Name 187 | 4 |  |  | 28 | 42
Name 188 | 4 |  |  | 52 | 74
Name 189 | 4 |  |  | 76 | 66
Name 190 | 4 |  |  | 64 | 58
Name 191 | 4 |  |  | 88 | 58
Name 192 | 4 |  |  | 60 | 46
Name 193 | 4 |  |  | 48 | 44
Name 194 | 4 |  |  | 64 | 60
Name 195 | 4 |  |  | 76 | 60
Name 196 | 4 |  |  | 76 | 68
Name 197 | 4 |  |  | 76 | 62
Name 198 | 4 |  |  | 68 | 40
Name 199 | 4 |  |  | 92 | 62
Name 200 | 4 |  |  | 76 | 64
Name 201 | 4 |  |  | 52 | 64
Name 202 | 4 |  |  | 84 | 74
Name 203 | 4 |  |  | 76 | 50
Name 204 | 4 |  |  | 68 | 46
Name 205 | 4 |  |  | 72 | 74
Name 206 | 4 |  |  | 52 | 56
Name 207 | 4 |  |  | 88 | 74
Name 208 | 4 |  |  | 72 | 60
Name 209 | 4 |  |  | 88 | 82
Name 210 | 4 |  |  | 80 | 56
Name 211 | 4 |  |  | 72 | 54
Name 212 | 4 |  |  | 64 | 44
Name 213 | 4 |  |  | 60 | 64
Name 214 | 4 |  |  | 72 | 62
Name 215 | 4 |  |  | 60 | 62
Name 216 | 4 |  |  | 48 | 48
Name 217 | 4 |  |  | 64 | 64
Name 218 | 4 |  |  | 56 | 46
Name 219 | 4 |  |  | 60 | 34
Name 220 | 4 |  |  | 72 | 58
Name 221 | 4 |  |  | 76 | 66
Name 222 | 4 |  |  | 64 | 60
Name 223 | 4 |  |  | 64 | 78
Name 224 | 4 |  |  | 84 | 64
Name 225 | 4 |  |  | 88 | 60
Name 226 | 4 |  |  | 68 | 64
Name 227 | 4 |  |  | 76 | 62
Name 228 | 4 |  |  | 60 | 68
Name 229 | 4 |  |  | 56 | 40
Name 230 | 4 |  |  | 80 | 74
Name 231 | 5 |  |  | 64 | 75
Name 232 | 5 |  |  | 76 | 70
Name 233 | 5 |  |  | 48 | 55
Name 234 | 5 |  |  | 68 | 65
Name 235 | 5 |  |  | 80 | 80
Name 236 | 5 |  |  | 60 | 60
Name 237 | 5 |  |  | 64 | 55
Name 238 | 5 |  |  | 52 | 65
Name 239 | 5 |  |  | 60 | 65
Name 240 | 5 |  |  | 68 | 75
Name 241 | 5 |  |  | 88 | 80
Name 242 | 5 |  |  | 76 | 75
Name 243 | 5 |  |  | 32 | 45
Name 244 | 5 |  |  | 60 | 70
Name 245 | 5 |  |  | 92 | 65
Name 246 | 5 |  |  | 72 | 85
Name 247 | 5 |  |  | 56 | 70
Name 248 | 5 |  |  | 48 | 50
Name 249 | 5 |  |  | 48 | 65
Name 250 | 5 |  |  | 64 | 60
Name 251 | 5 |  |  | 40 | 50
Name 252 | 5 |  |  | 56 | 55
Name 253 | 5 |  |  | 62 | 55
Name 254 | 5 |  |  | 52 | 60
Name 255 | 5 |  |  | 32 | 40
Name 256 | 5 |  |  | 56 | 65
Name 257 | 5 |  |  | 72 | 65
Name 258 | 5 |  |  | 80 | 75
Name 259 | 5 |  |  | 40 | 65
Name 260 | 5 |  |  | 64 | 70
Name 261 | 5 |  |  | 36 | 60
Name 262 | 5 |  |  | 36 | 55
Name 263 | 5 |  |  | 72 | 65
Name 264 | 5 |  |  | 76 | 65
Name 265 | 5 |  |  | 80 | 90
Name 266 | 5 |  |  | 40 | 65
Name 267 | 5 |  |  | 68 | 75
Name 268 | 5 |  |  | 56 | 65
Name 269 | 5 |  |  | 36 | 55
Name 270 | 5 |  |  | 80 | 75
Name 271 | 5 |  |  | 36 | 40
Name 272 | 5 |  |  | 60 | 55
Name 273 | 5 |  |  | 40 | 75
Name 274 | 5 |  |  | 56 | 80
Name 275 | 5 |  |  | 32 | 45
Name 276 | 5 |  |  | 68 | 70
Name 277 | 5 |  |  | 60 | 70
Name 278 | 5 |  |  | 80 | 70
Name 279 | 5 |  |  | 52 | 60
Name 280 | 5 |  |  | 88 | 80
Name 281 | 5 |  |  | 56 | 67
Name 282 | 5 |  |  | 56 | 70