Any Excel guru's out there that can help me

[Brutus Brewer]

I am writing a spread sheet to score our annual golf tournament next weekend and am having some difficulties getting the correct formula. We are playing a points game where you get 1 point for bogey, 2 for par, 3 for birdie, and 5 for eagle, and are only counting the 3 best points on the hole. My thought was to sum the range and subtract the min value, however if there are 2 of the same minimum value on the hole Excel doesn't count any of them. Any ideas?

 

[GilaMinumBeer]

Sounds to me like a combination of a VLookup for the text to digit values followed by a conditional format to sort highest to lowest then a Sum.

 

[Brutus Brewer]

I got it, I guess using an array formula and that looks like this:

=SUM(ABS(AG126:AG129))-(MIN(ABS(AG126:AG129)*1))

 

[bmhalula]

or you could use a sumif. something like this.

=SUMIF(B2:B19,">1")

you could use it to get total for hole and per person. Hope it helps.