Ask Your Question
0

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

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

image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

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:

=SUMPRODUCT(LARGE(B2:L2;{1;2;3;4;5;6}))
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 23 times

Last updated: Nov 03