Exclude Scores

[SCgrant327]

I am working on a scoring spreadsheet. I would like to know how to exclude some scores from a SUM.

Example:

You compete in 16 events, but only your top 12 places will count toward your overall score.

What Excel functions should I use to Sum only the top 'n' scores?

Thanks!

 

[Aladin Akyurek]

Re: Maybe a better explanation

There are 24 possible events to participate in, 6 days of 4 events. If you compete in more than 66%, then your best 66% placements will count toward an overall. If you compete in less than 66%, then you will not be considered for the overall.

So, what I need to do is calculate the sum of your best 66% scores. The scores are in the same row, from H4::AE4. If you compete in less than the total 24 races, your score will be 0 for those that you did not compete in and those will NOT count toward your 66% participation.

Control+shift+enter...

=SUM(LARGE(IF(H4::AE4>0,H4::AE4),ROW(INDIRECT("1:"&ROUND(COUNT(H4::AE4)*0.66,0)))))