Any Excel guru's out there that can help me

Help Support Homebrew Talk - Beer, Wine, Mead, & Cider Brewing Discussion Forum:

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
HBT Supporter
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
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.

Replies
5
Views
2K
Replies
2
Views
3K
Replies
3
Views
561
Replies
1
Views
296
Replies
2
Views
662