Our senior golf league is for recreation only, we play 20 to 30 times
per season. Most players do not want to maintain an official handicap.
I would like to develop a spreadsheet to calculate handicaps based
loosely on the USGA method. Part of that method is to calculate a
differential based upon lowest scores. I need a formula that will do
the following, 1 to 8 scores average the lowest 2, 9 to 13 scores
average lowest 4, 14-16  enteries average lowest 6, 17-19 enteries
average lowest 8, 20 or more average lowest 10.

---

Clarification of Question by average-ga on 27 Mar 2006 17:14 PST

Somethinglikeant,
 
What I am asking for is a formula  or formula's that will do the
calculations as stated in the question. I can build the spreadsheet
around that and the other required formulas. The posting at the link
you provided is not what I want,

---

Clarification of Question by average-ga on 22 Apr 2006 09:07 PDT

Somethinglikeant,

Thanks for your contribution to my question, using the formulas you
provided and formulas obtained from other places I was able to develop
a spreadsheet that  will meet my goals.

I would have game number going accross the top and players in rows down the side. 
Some clever use of the small(), count, countif functions should be all
you need. Let me know if you would like me to do this for you.
I do this kind of work as a profession so I assure you i will give you
what you need.

Anthony

Hi,

somethinglikeant-ga,

The posting of personal contact information such as email addresses is
not permitted on Google Answers. If you have something useful to offer
the customer (for free), you'll need to post it here as a comment, or
post a URL that leads to the material.

http://uk.geocities.com/somethinglikeant@btinternet.com/golfhandicaps.html

Apologies, as you cannot view the formulas on this version I uploaded.
The formulas you should need are as follows
for Number of games played 
=COUNT(B3:AE3), simply counts up how many scores are entered for each
player as you need this in a later formula.
If you copy this down for how many rows you need it will work throughout the table
Under lowest scores, 
1st lowest score
=IF(ISERROR(LARGE($B3:$AE3,AG$2)),"-",LARGE($B3:$AE3,AG$2))
if you copy this accross to 10th lowest score and down for how many
players ypou need this should work

Formula to work out handicap
=IF(AF4=0,"",IF(AF4<=8,AVERAGE(AG4:AH4),IF(AF4<=13,AVERAGE(AG4:AJ4),IF(AF4<=16,AVERAGE(AG4:AL4),IF(AF4<=19,AVERAGE(AG4:AN4),AVERAGE(AG4:AP4))))))

again if you need this for many players just copy down.

search in Excels help facility if you need clarification of what each formula does
average(),if(),large(),count(),iserror()