=SUM(LARGE(A1:A12,ROW(1:9))

it is an array formula, so commit it with Ctrl-Shift-Enter.

--
HTH

Bob Phillips

"Vance Burton" <Vance wrote in message
...
I need to keep track of the scores in a quiz for 12 weeks running, then
total
each contestant's best 9 scores.

Is there any way to sum a column, automaticaly ignoring the 3 worst
scores?