Hi,

I am looking for a formula to calculate the average Points scored at various segments to plot trends.

I'm trying to get the last game trends in 5 game sets (ie, last 5 games, last 6 - 10 games, last 11-15 games)

This is the formula I am using to get the last 5 games:

HTML Code: 
I am guessing it is the "+1" in the code that perhaps I need to change to alter the average. But, I've tried changing the number but nothing seems to work.

Any help, much appreciated.

Ken