Average of averages Excel formula
<p>how do I make a single formula that will take the n-week average of m-week averages?</p>

<p>Suppose I have data in <code>A2:A21</code>, and in <code>D21</code>, I want the 8 week average of 4-week moving averages up to A21.  So my idea would be</p>

<pre><code>{=AVERAGE(AVERAGE(OFFSET(A21,-4+1-ROW(OFFSET(A1,0,0,8))+1,0,4)))}
</code></pre>

<p>So for example, with this data:</p>

<pre><code>data    4 wk aver   8 wk avg avg
79      
79      
66      
38  66  
34  54  
13  38  
22  27  
50  30  
40  31  
98  53  
81  67  46
27  62  45
64  68  47
12  46  48
83  47  50
94  63  54
4   48  57
41  56  57
4   36  53
6   14  47
</code></pre>

<p>I am looking for a formula to calculate 47... My formula above calculates 57.8.</p>