need formula for average of rolling 4 rows in excel document
 

Hi everyone. I need to have a formula to achieve an average figure for a
rolling 4 rows, ie at the 5th row, discard the 1st row and re-average rows
2-5 inclusive, at the 6th row discard the 1st and 2nd rows and re-average
rows 3-6 inclusive..ad infinitum. I'm using microsoft excel.Thanks in
anticipation..Mary

need formula for average of rolling 4 rows in excel document
 

Let's say your numbers are in A1:A100
In B4 enter =AVERAGE(A1:A4)
Copy this down the column
Need more?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"radimum" wrote in message
...
Hi everyone. I need to have a formula to achieve an average figure for a
rolling 4 rows, ie at the 5th row, discard the 1st row and re-average rows
2-5 inclusive, at the 6th row discard the 1st and 2nd rows and re-average
rows 3-6 inclusive..ad infinitum. I'm using microsoft excel.Thanks in
anticipation..Mary