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

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