#### cunningAce

##### Board Regular

- Joined
- Dec 21, 2017

- Messages
- 86

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: