View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

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