Golf averages
 

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

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

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