cunningAce
Board Regular
- Joined
- Dec 21, 2017
- Messages
- 91
- Office Version
- 365
- Platform
- Windows
Hi,
Hoping someone could help me with the following please,
I am looking to find the average of a range of numbers (determined by the variable in the 'weeks average' cell)
So in the below examples, I want the average of the last 5 weeks for each set of numbers.
I want to ignore any zeros after the last weeks figures (week 8 in these examples) but include any zeros within the 5 week average,
Eg,
The first line would calculate an average for weeks 4-8 - (0,10,50,60,100 = 44)
The 3rd line would also calculate weeks 4-8 ignoring anything before, and any zeros after week 8. (5,10,50,60,200 = 65)
Hope this makes sense,
Thanks in advance,
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
Hoping someone could help me with the following please,
I am looking to find the average of a range of numbers (determined by the variable in the 'weeks average' cell)
So in the below examples, I want the average of the last 5 weeks for each set of numbers.
I want to ignore any zeros after the last weeks figures (week 8 in these examples) but include any zeros within the 5 week average,
Eg,
The first line would calculate an average for weeks 4-8 - (0,10,50,60,100 = 44)
The 3rd line would also calculate weeks 4-8 ignoring anything before, and any zeros after week 8. (5,10,50,60,200 = 65)
Hope this makes sense,
Thanks in advance,
B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|
3 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Average |
4 | 0 | 0 | 0 | 0 | 10 | 50 | 60 | 100 | 0 | 0 | 44 |
5 | 0 | 0 | 0 | 5 | 10 | 50 | 60 | 100 | 0 | 0 | 45 |
6 | 2 | 4 | 6 | 5 | 10 | 50 | 60 | 200 | 0 | 0 | 65 |
7 | |||||||||||
8 | |||||||||||
9 | Weeks Average | 5 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
<tbody>
</tbody>
Last edited: