I’m trying to get an excel spread sheet to get Golf handicaps using the lowest 5 of last 6 scores?
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!
What I meant was that I would just use the average if they had less than 6 scores!
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)
