Ask Your Question

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

asked 2019-11-02 22:23:09 +0100

grantalias gravatar image


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?


image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-11-03 07:42:14 +0100

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-11-02 22:23:09 +0100

Seen: 23 times

Last updated: Nov 03