# Any Excel guru's out there that can help me

### Help Support Homebrew Talk:

#### Brutus Brewer

##### Well-Known Member
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

##### Half-fast Prattlarian
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.

OP
B

#### Brutus Brewer

##### Well-Known Member
I got it, I guess using an array formula and that looks like this:

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

#### bmhalula

##### Member
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.