How do I add only the highest three numbers in a range of data?
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.
|