Try...

=AVERAGE(INDEX(A1:A20,LARGE(IF(A1:A20<"",ROW(A1:A 20)-ROW(A1)+1),8)):INDE
X(A1:A20,MATCH(9.99999999999999E+307,A1:A20)))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"Golf Averages" wrote:

There are 24 players in my golf league. I would like to get a running average
of the last scores midway thru the season which runs for 20 weeks. I need the
average of the last 8 scores submitted and not just an average of the last 8
weeks which could have one or more missing scores.
51
52
49
46
42
43
43
45
43
45
47
39

44

45
47

50