Any Excel guru's out there that can help me

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

Help Support Homebrew Talk:

Brutus Brewer

Well-Known Member
Joined
Jul 12, 2006
Messages
468
Reaction score
21
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
Lifetime Supporter
Joined
Jan 23, 2008
Messages
65,437
Reaction score
10,794
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
Joined
Jul 12, 2006
Messages
468
Reaction score
21
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
Joined
Jun 19, 2011
Messages
20
Reaction score
0
Location
Apex
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.
 
Top