Get an average of top 50% of results

Hello,

I am trying to find a forumla to obtain an average of the best 3 scores out of a set of 6.

E.g.
Round 1 - 2points
Round 2 - 4points
Round 3 - 2points
Round 4 - 4points
Round 5 - 4points
Round 6 - 2points

For the simplified example above, the scores for rounds 2,4 and 5 would be used giving an average of 4. Any ideas folks?

Here, try this:

=AVERAGE(LARGE(A1:A100;{1;2;3}))

(replace ; with , if you get error)

Ah ha! That worked fine.

Corrected it to:

AVERAGE(LARGE(A1:A100,{1;2;3}))

Solved. Thanks for the quick reply.