Find the top 6 numbers in a row and only add them to a total


I have a score sheet for a small sailing club that I manage. Our seasons have 11 races but only the top 6 race day scores are kept. This allows you to drop you lowest scores. I am finding the top 6 scores manually and would like to automate it.

What is the formula(s) I would need to do that?


Use LARGE spreadsheet function. Given you have your Boat 1 data in cells B2:L2, put this to M2: