john

=SUM(SMALL(A1:A10,{1,2,3}))

array formula so enter with CTRL + SHIFT + ENTER

returns the sum of the 3 smallest scores


Gord Dibben Excel MVP

On Sat, 26 Nov 2005 13:46:49 GMT, "john cornell"
wrote:

I have a list of scores (10)from golfers I want to pick the three best
scores. Each golfer has a row. After I get the three scores I can apply the
GHIN system to come up with a handicap. Is there a way to have a program
pick the three best for each golfer or do I have to do it manually?

Thanks in advance