Thanks but this doesn't seem to be working for me. Also, I'd like to be able
to vary the number of top scores included based on a referenced cell.

"Peo Sjoblom" wrote:

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