I have included a workbook with this. In column B what I need is the average of the last 5 games a team has played. C being there first game. So for example in row 2 I need the average of air force for games 9 thru 13 so column J thru O. Whereas in row 3 I need Akron for games 7 thru 11, I thru M. Now in row 19 for Brown, I need to average 2, 3, 8,9 and 10 because there is no data for 4 thru 7.
Bookmarks