Hello Everyone,
I am stuck on the best formula to use here. What I am looking to do is have Excel use only the last 10 weeks worth of data to produce an average even when adding in a new week to the report every week, so I want it to adjust that automatically if possible, or maybe use some type of drag formula to make it read correctly, but I am stuck at how to do that.
On the sheet below the weeks are shown as 1-13, the calls are shown to the right of the times columns.
Thanks in Advance!
Lenny
I am stuck on the best formula to use here. What I am looking to do is have Excel use only the last 10 weeks worth of data to produce an average even when adding in a new week to the report every week, so I want it to adjust that automatically if possible, or maybe use some type of drag formula to make it read correctly, but I am stuck at how to do that.
On the sheet below the weeks are shown as 1-13, the calls are shown to the right of the times columns.
Monday | Avg Number of Calls on last 10 weeks | ||||||||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | |||
9-930 | 20 | 25 | 30 | 25 | 28 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | ||
930-10 | 15 | 28 | 30 | 23 | 32 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | 28 | ||
10-1030 | 8 | 30 | 16 | 20 | 12 | 11 | 11 | 8 | 30 | 16 | 20 | 11 | 11 | ||
1030-1100 | 7 | 25 | 30 | 25 | 28 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 |
Thanks in Advance!
Lenny