Conditional sum based on rank

M

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
 
M

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
 
Top