Thread: need formula for average of rolling 4 rows in excel document
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default 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


Reply With QuoteReply With Quote