Spreadsheet: 691966d1597981623-average-formula-every-10th-row-based-on-another-column-sample
Sheet: Sheet1

Name | Week | Team | A | B | C | D | E | F | G | H | I | J | AVGE
AR | 1 | G | 30 | 44 | 303 | 2 | 1 | 3 | 5 | 27 | 0
AR | 2 | G | 22 | 32 | 219 | 1 | 1 | 5 | 3 | -6 | 0
AR | 3 | G | 26 | 39 | 223 | 0 | 0 | 8 | 2 | 17 | 0
AR | 4 | G | 31 | 41 | 319 | 4 | 1 | 0 | 5 | 13 | 0
AR | 5 | G | 20 | 32 | 235 | 3 | 1 | 5 | 5 | 57 | 0
AR | 6 | G | 24 | 37 | 338 | 6 | 0 | 2 | 2 | 17 | 0
AR | 7 | G | 30 | 37 | 342 | 3 | 0 | 3 | 2 | 0 | 0
AR | 8 | G | 22 | 35 | 186 | 2 | 0 | 2 | 3 | 4 | 0
AR | 9 | G | 14 | 30 | 218 | 4 | 1 | 1 | 8 | 33 | 0
AR | 11 | G | 19 | 27 | 236 | 2 | 1 | 3 | 1 | 3 | 0
AR | 12 | G | 14 | 25 | 219 | 1 | 1 | 5 | 3 | 22 | 0
AR | 13 | G | 27 | 35 | 286 | 1 | 1 | 2 | 4 | 15 | 0
AR | 14 | G | 14 | 24 | 173 | 0 | 0 | 3 | 3 | 32 | 1
AR | 15 | G | 23 | 36 | 291 | 3 | 0 | 3 | 4 | 14 | 0
AR | 16 | G | 27 | 38 | 342 | 3 | 0 | 1 | 4 | 11 | 1
AR | 17 | G | 28 | 40 | 365 | 4 | 0 | 5 | 0 | 0 | 0
AR | 18 | G | 23 | 33 | 274 | 1 | 0 | 3 | 2 | 12 | 0
AR | 19 | G | 26 | 39 | 257 | 2 | 1 | 1 | 3 | 28 | 0
AS | 1 | S | 20 | 26 | 211 | 2 | 0 | 4 | 5 | 13 | 0
AS | 2 | S | 20 | 31 | 226 | 2 | 0 | 3 | 4 | 7 | 0
AS | 3 | S | 24 | 35 | 204 | 1 | 1 | 3 | 4 | 26 | 0
AS | 4 | S | 12 | 21 | 143 | 0 | 0 | 2 | 3 | 12 | 0
AS | 5 | S | 18 | 24 | 303 | 3 | 0 | 0 | 3 | 49 | 0
AS | 6 | S | 19 | 30 | 200 | 0 | 3 | 4 | 2 | 5 | 0
AS | 7 | S | 14 | 23 | 140 | 1 | 1 | 2 | 5 | 11 | 0
AS | 8 | S | 18 | 19 | 232 | 3 | 0 | 4 | 1 | 6 | 0
AS | 10 | S | 7 | 8 | 72 | 1 | 0 | 2 | 2 | 5 | 0
AS | 17 | S | 1 | 1 | 6 | 0 | 0 | 0 | 2 | -2 | 0 |  |  |  | <---- formula should appear here
AL | 1 | I | 23 | 45 | 309 | 1 | 3 | 3 | 2 | 9 | 0
AL | 2 | I | 20 | 31 | 224 | 2 | 0 | 2 | 4 | 21 | 0
AL | 3 | I | 22 | 46 | 313 | 2 | 1 | 0 | 4 | 50 | 0
AL | 5 | I | 31 | 55 | 362 | 2 | 1 | 4 | 6 | 24 | 1
AL | 6 | I | 22 | 44 | 280 | 0 | 2 | 4 | 1 | -1 | 0
AL | 7 | I | 16 | 29 | 186 | 0 | 0 | 3 | 3 | 12 | 2
AL | 8 | I | 26 | 38 | 297 | 1 | 1 | 2 | 6 | 28 | 0
AL | 9 | I | 30 | 48 | 433 | 2 | 0 | 1 | 1 | 5 | 0
AL | 10 | I | 18 | 26 | 227 | 0 | 1 | 2 | 7 | 11 | 2
AL | 11 | I | 27 | 50 | 334 | 2 | 3 | 1 | 1 | 4 | 0 |  |  |  | <---- formula should appear here
AL | 12 | I | 20 | 37 | 240 | 1 | 1 | 4 | 6 | 20 | 0
AL | 13 | I | 24 | 54 | 391 | 4 | 3 | 2 | 3 | 33 | 0
AL | 14 | I | 16 | 34 | 196 | 1 | 2 | 4 | 5 | 7 | 0
AL | 15 | I | 13 | 27 | 186 | 2 | 0 | 5 | 2 | 10 | 0
AL | 16 | I | 17 | 35 | 205 | 1 | 0 | 3 | 6 | 21 | 0
AL | 17 | I | 14 | 28 | 191 | 2 | 0 | 1 | 5 | 1 | 0
AL | 18 | I | 28 | 54 | 288 | 0 | 1 | 3 | 4 | 35 | 0
AD | 1 | C | 22 | 37 | 221 | 0 | 1 | 4 | 3 | 11 | 0
AD | 2 | C | 24 | 31 | 318 | 3 | 1 | 6 | 3 | 4 | 0
AD | 3 | C | 19 | 27 | 328 | 3 | 1 | 2 | 2 | 16 | 0
AD | 4 | C | 20 | 31 | 244 | 2 | 1 | 0 | 6 | 5 | 1
AD | 5 | C | 26 | 43 | 234 | 1 | 2 | 3 | 4 | 21 | 0
AD | 6 | C | 31 | 46 | 381 | 3 | 3 | 2 | 2 | 5 | 0
AD | 7 | C | 14 | 28 | 105 | 1 | 1 | 0 | 1 | -1 | 0
AD | 9 | C | 26 | 42 | 299 | 1 | 1 | 5 | 2 | 16 | 0
AD | 10 | C | 21 | 30 | 199 | 4 | 0 | 0 | 2 | -2 | 0
AD | 11 | C | 18 | 29 | 230 | 2 | 0 | 2 | 3 | 13 | 1 |  |  |  | <---- formula should appear here
AD | 12 | C | 16 | 30 | 210 | 3 | 0 | 2 | 4 | 5 | 0
AD | 13 | C | 25 | 38 | 211 | 1 | 2 | 1 | 4 | 5 | 1
AD | 14 | C | 20 | 33 | 206 | 1 | 1 | 5 | 1 | 0 | 0
AD | 15 | C | 13 | 27 | 127 | 1 | 0 | 6 | 8 | 18 | 1
AD | 16 | C | 24 | 41 | 278 | 0 | 2 | 6 | 0 | 0 | 0
AD | 17 | C | 10 | 15 | 78 | 1 | 0 | 2 | 2 | 4 | 0
AD | 18 | C | 14 | 30 | 127 | 0 | 1 | 2 | 4 | 15 | 0