Formula to Calculate Average to nth to nth row

[ken_trenholm]

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:

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

[martindwilson]

=AVERAGE(INDEX($C:$C,MATCH(10^99,$C:$C,1)):INDEX($C:$C,MATCH(10^99,$C:$C,1)-5+1))
=AVERAGE(INDEX($C:$C,MATCH(10^99,$C:$C,1)-6+1):INDEX($C:$C,MATCH(10^99,$C:$C,1)-10+1))
=AVERAGE(INDEX($C:$C,MATCH(10^99,$C:$C,1)-11+1):INDEX($C:$C,MATCH(10^99,$C:$C,1)-15+1))
would give last 5 second to last 5 and 3rd to last 5
so for c3:c34 that would give
c30:c34
c25:c29
and c20:c24

[ken_trenholm]

Thanks so much!

That works perfectly.

Ken