Hi!

Try this entered as array using the key combo of CTRL,SHIFT,ENTER:

=AVERAGE(A100:INDEX(A1:A100,LARGE(IF(A1:A100<"",R OW(A1:A100)),8)))

Use a big enough range to cover any future entries!

Biff

"Golf Averages" wrote in message
...
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