cunningAce
Board Regular
- Joined
- Dec 21, 2017
- Messages
- 91
- Office Version
- 365
- Platform
- Windows
Hi,
I am looking for a way to calculate an average total dependant on the selections made.
So in this example the selections are 'Code' = A1 and 'Weeks Avg' = 4
The answer should be 29.66 as I want the formula to average the last 4 weeks figures for anything with code A1.
<colgroup><col><col span="8"></colgroup><tbody>
</tbody>
I am looking for a way to calculate an average total dependant on the selections made.
So in this example the selections are 'Code' = A1 and 'Weeks Avg' = 4
The answer should be 29.66 as I want the formula to average the last 4 weeks figures for anything with code A1.
<colgroup><col><col span="8"></colgroup><tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Thanks in advance | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col><col span="8"></colgroup><tbody>
</tbody>