Help - golf society formula conundrum

[cerbera1972]

Hi, apologies if this is a very simple question. I manage a golf society - we play 7 times a year and post a stableford score. The winner for the year is the person with the highest total of their best 5 scores.
I have each persons score in a line - is there a formula that can identify and add together the top 5 scores for each person? Thanks again for any help you may have

[tigertiger]

Hi, apologies if this is a very simple question. I manage a golf society - we play 7 times a year and post a stableford score. The winner for the year is the person with the highest total of their best 5 scores.
I have each persons score in a line - is there a formula that can identify and add together the top 5 scores for each person? Thanks again for any help you may have

Try to use the LARGE function in excel sheet, plz see the link
https://support.office.com/en-za/art...rs=en-ZA&ad=ZA

[cerbera1972]

Thankyou tigertiger for taking the time to respond - much appreciated. I have read through the link and think I understand how the LARGE function can determine the 1st largest number or the 3rd largest number etc. However I can't see how that will enable me to determine the 5 largest numbers from a sequence of 7 and total those largest 5 numbers.

Apologies - I am not a very capable excel user so sorry if I can't make the jump.....

[Glenn Kennedy]

Assuming data for the first player are in B2 to H2, use

=SUM(LARGE(B2:h2,{1,2,3,4,5}))

[cerbera1972]

Glenn - you're a legend thanks, it works !! Much appreciated

[Glenn Kennedy]

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.