View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default how do i remove 5 lowest scores?

=SUM(LARGE(A1:A100,ROW(INDIRECT("1:"&COUNT(A1:A100 )-5))))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"bil-bil" wrote in message
...
i am very new to using excels, but have built a little tournament sheet.

we
are holding 40 games in the tournament and are dropping the 5 lowest

scores.
please help thankyou in advance.