Name your range of scores "golfscores". Some of the cells may be blank,
possibly for additional future scores to be entered. I have taken this to be
in column A.
In cell B1 enter
=IF(ISBLANK(A1)=FALSE,A1+ROW(A1)/1000,1000*ROW(A1))
Copy down and name this range "uniquescores". Golfscores and Uniquescores
must have the same number of cells.
In cell C1 enter
=SUMPRODUCT(--(uniquescores<=$B1))
Copy down and name the range "Places". This must also have the same number
of cells as the other two named ranges.
Cells D1 to D10 contain the numbers 1 to 10.
In cell E1 enter
=SUMPRODUCT(golfscores,--(places=$D1))
Copy down to cell E10.

"JPreeshl" wrote:

I am trying to figure out a golf handicap. I need to add the 10 lowest
scores out of a range of numbers that will always be changing as I add more
golf scores. Is there a formula for this?