Hi,
I need to know a formula which will work out an average based on the following:
- Row A represents game weeks (e.g. week 1, week 2, etc.)
- Week 6 is the most recent week, week 5 is the next most recent week, etc.
- Row B represents points scored in each game week, e.g. week 6 = 5 points, week 5 = 0 points, etc.
- The blank values (e.g. week 4 and week 2) there was no game
I need the formula to calculate the average points scored in the three most recent weeks where there has been a game, e.g. the formula would need to calculate the average of weeks 6, 5 and 3 in the example below, i.e. (5 + 0 + 1)/3 = 2 points.
<colgroup><col span="6"></colgroup><tbody>
</tbody>
I'm struggling with this. Many thanks for your help.
I need to know a formula which will work out an average based on the following:
- Row A represents game weeks (e.g. week 1, week 2, etc.)
- Week 6 is the most recent week, week 5 is the next most recent week, etc.
- Row B represents points scored in each game week, e.g. week 6 = 5 points, week 5 = 0 points, etc.
- The blank values (e.g. week 4 and week 2) there was no game
I need the formula to calculate the average points scored in the three most recent weeks where there has been a game, e.g. the formula would need to calculate the average of weeks 6, 5 and 3 in the example below, i.e. (5 + 0 + 1)/3 = 2 points.
6 | 5 | 4 | 3 | 2 | 1 |
5 | 0 | 1 | 8 |
<colgroup><col span="6"></colgroup><tbody>
</tbody>
I'm struggling with this. Many thanks for your help.