One way

=AVERAGE(LARGE($A$1:$A$100,ROW(INDIRECT("1:10"))))

entered with ctrl + shift & enter

regards,

Peo Sjoblom

"Jake" wrote:

How do I tell excel to look at only the top x numbers in a list of values?
For example, if I have 100 scores and I want Excel to calculate the average
of the top 10 scores, how do I do that?

Thanks