Hi!
=SUM(LARGE(A1:A20,{1,2,3}))
Biff
-----Original Message-----
I am using Excel to record, add and rank scores for a
gymnastics meet. We
have teams of as many as 20 girls, but only the top three
scores count
towards a team score. How can I program a SUM function
that adds only the
highest three scores.
.
|