Experiment with this
=SUM(A1:A100)-SUM(SMALL(A1:A100,{1,2,3,4,5}))
If a number occurs twice (as one of the lowest 5) it is discounted twice
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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.