how to count top ten results from 16?

I

iamstellaman

Hi, i have alimited knowledge of excel,
i am trying to compile a points table for a 16 round race meeting, onl
the top ten scores are to count though, how do i get excel to do this??
Thanks in anticipation!!
Mar
 
F

Frank Kabel

Hi
have a look at the LARGE function. e.g. for summing use
=SUMIF(A1:A100,">=" & LARGE(A1:A100,10))

Note: may not work if you have duplicates in the range. Another
version:
=SUM(LARGE(A1:A100,{1,2,3,4,5,6,7,8,9,10}))
 
Top