Conditional sum based on rank

[Mike B]

Can anyone help with the following, or direct me to a good source of
solution info!

I'm recording positions for a race league, where competitors may race in up
to 12 races and score points for each race, with the best 8 results
counting. How can I conditionally sum the best eight results, without
including ties?

Many thanks
MikeB

 

[JMay]

This will no doubt help you.
http://www.cpearson.com/excel/rank.htm

 

[Mike B]

I actually solved this myself, and it's embarrassingly simple:

If Count(Range)<=8 then
Sum(Range)
else
Large(Range,1)+Large(Range,2)+Large(Range,3)......

Oh well, it was 4am when I looked at this....
m