I'm trying to get an excel spread sheet to get Golf handicaps using the lowest 5 of last 6 scores?

Question

I need one for 5 lowest of last 6 sores with blanks and less, with 1 or more scores!

I have manipulated the other formulas until I am blue in the face and cannot get it to work; I need help from someone much smarter than me!

If anyone can help me, I would greatly appreciate it!

Answer 1

im not a golfer

it would help if you provide a good sample

need some cell references, and what you mean by blanks and less

i am guessing your sheet looks something like this

a1 89

a2 90

a3 blank

a4 91

a5 92

a6 93

and you want the 5 lowest averaged?

maybe you coluld sample the b column for other questions.

what does the 1 or more mean? is that 1 score and 5 blanks?

edit

see if this works for you

put it together in 1 cell

=IF(COUNTBLANK(A1:A6)>0,AVE

RAGE(A1:A6),(SUM(A1:A6)-MAX(A1:A6))/5)

Answer 2

You really can't do this very well.

A HC is a function of the actual score on a course that has a slope rating.  So that the same score on two different courses with different ratings will affect your HC differently.  Addionally, HCs are a measure of a golfers capability, not of what they did... The final HC is not the 'weighted' average of the score, but rather a percentage (I think it is 96%) of that weighted average.

If you hit your local USGA section site, there is a whole section on HCs and how they are computed.