Spreadsheet: 766339d1643851931-how-to-calculate-average-of-a-list-of-cells-within-a-formula-example
Sheet: Sheet1

 | Table 1 - current figures |  |  |  |  |  |  |  |  |  |  |  |  | Table 2 - expected result
 |  |  |  |  | Planting Year |  |  |  |  |  |  |  |  |  |  |  |  |  | Planting Year
Project Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | AVERAGE(B4:B33) |  | Project Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 220.3445557875 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 1 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 253.74214614 | 220.3445557875 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 2 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 253.74214614 | 253.74214614 | 220.3445557875 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 3 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 253.74214614 | 253.74214614 | 253.74214614 | 220.3445557875 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 4 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0 | 0
5 | 253.74214614 | 253.74214614 | 253.74214614 | 253.74214614 | 220.3445557875 | 0 | 0 | 0 | 0 | 0 |  |  |  | 5 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
6 | 253.74214614 | 253.74214614 | 253.74214614 | 253.74214614 | 253.74214614 | 0 | 0 | 0 | 0 | 0 |  |  |  | 6 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
7 | 2.7500025 | 253.74214614 | 253.74214614 | 253.74214614 | 253.74214614 | 0 | 0 | 0 | 0 | 0 |  |  |  | 7 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
8 | 2.7500025 | 2.7500025 | 253.74214614 | 253.74214614 | 253.74214614 | 0 | 0 | 0 | 0 | 0 |  |  |  | 8 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
9 | 2.7500025 | 2.7500025 | 2.7500025 | 253.74214614 | 253.74214614 | 0 | 0 | 0 | 0 | 0 |  |  |  | 9 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
10 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 253.74214614 | 0 | 0 | 0 | 0 | 0 |  |  |  | 10 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
11 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 11 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
12 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 12 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
13 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 13 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
14 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 14 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
15 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 15 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
16 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 16 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
17 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 17 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
18 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 18 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
19 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 19 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
20 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 20 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
21 | 0 | 2.7500025 | 2.7500025 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 21 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
22 | 0 | 0 | 2.7500025 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 22 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
23 | 0 | 0 | 0 | 2.7500025 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 23 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
24 | 0 | 0 | 0 | 0 | 2.7500025 | 0 | 0 | 0 | 0 | 0 |  |  |  | 24 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 25 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 26 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 27 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 28 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 29 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0
30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 30 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 50.91851071624997 | 0 | 0 | 0 | 0 | 0