I'm trying to calculate a 3 month average for a set of data but when I type in =average(d2:d4) and drag it down, the next box displays d3:d5 when i need it to take the average of d5:d7. Is there a way I could tweak the formula to do this for me? thanks in advance
How does it become "rolling average" when you don't want it rolling? You have stated that you would like to average D2:D4 and then D5:D7. This is not rolling average.
You could try =AVERAGE(INDIRECT("D" & (ROW()-1)*3+2 & ":D" & (ROW()-1)*3+4))
Try:
=AVERAGE(INDEX($D$2:$D$100,1+((ROW(A1)-1)*3)):INDEX($D$2:$D$100,3+((ROW(A1)-1)*3)))
adjust ranges to suit, and copy down.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks