You can use an array formula to total the top scores. For example, with
scores in cells B2:B100 --
=SUM(LARGE(B2:B100,ROW(INDIRECT("1:3"))))
To array enter the formula, hold the Ctrl and Shift keys, then press Enter.
There's an example he
http://www.contextures.com/xlFunctions01.html#Top5
emac_mommy wrote:
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.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html