Totaling the best 4 points

Hello

I looking at a spreadsheet to add up the best 4 skippers from different radio controlled sailing clubs at a interclub regatta.
the scoring is done by sailing scoring systems that can be exported to excel, yes it can be done mechanically by adding the individual scores.

In the attached spreadsheet I have labelled the clubs "A" to "F" (column C) and the skippers individual scores (column D) with the sum of best 4 skippers points from club "A" ........to ....."F" in cells D60 to D65.


Thank you for your help.

Not sure I get it, but maybe you could try this array entered in D60 (paste formula and confirm with Ctrl+Shift+Enter instead of just Enter), then copy down:

Formula:

Please Login or Register  to view this content.

Good luck!

If I understood it right the best skipper is the one with the smallest points, in that case the formula of Bo_Ry should be:

Formula:

Please Login or Register  to view this content.

You would also want to see the 4 best numbers and a new rank of the sum...

Thank you for your help, much appreciated.