Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating averages | Excel Discussion (Misc queries) | |||
how to use the Prob function in a list of averages to find the le | Excel Worksheet Functions | |||
Golf Pool | Excel Discussion (Misc queries) | |||
Converting Weekly Data into Monthly Averages | Excel Discussion (Misc queries) | |||
Averages | Excel Worksheet Functions |