need formula for average of rolling 4 rows in excel document

R

radimum

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
 
B

Bernard Liengme

Let's say your numbers are in A1:A100
In B4 enter =AVERAGE(A1:A4)
Copy this down the column
Need more?
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering results in excel 0
how do i calculate a 4 week rolling average 1
Average with criteria for adjacent cells ? 1
Need to average data if in cells, but ignore blank cells. 4
Excel message box 5
Excel formula 5
Sorting rows out of order after all rows are numbered in sequence 1
Changing Average - Ongoing for Excel 2007 2

Top