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

[grantalias]

Hello,

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?

Thanks

[mikekaganski]

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

=SUMPRODUCT(LARGE(B2:L2;{1;2;3;4;5;6}))