Hi all,
First time poster, I have done quite a lot of searching trying to work out how to do this. Have found a lot of examples but not one that quite works for what I need it to do.
In sheet 1 (TEAM SHEETS), I want to create a 3 game rolling average (D6) for the data in sheet 2, D5, F5, and H5. And as the data is entered for J5 I receive a new 3 game average rolling average for F5, H5 and J5 in that same cell.
For example, the corresponding data in D5, F5, and H5 should return a 3 game rolling average of 4.3 in Sheet 1 D6. As the next value is entered into J5, Sheet 1 D6 will then change to represent the new 3 game average of 6.16. And so forth until the 82nd game at the end of the worksheet.
I would also like to do this same process for a 5 game average in Sheet 1 E6.
I hope that makes sense, if any one could help me out that would be great!
I have attached the relevant spreadsheet.
Bookmarks