=AVERAGE(LARGE(A1:A100,ROW(INDIRECT("1:"&E1))))

Array-entered, where E1 holds the nth largest value to include in the average.

HTH
Jason
Atlanta, GA

"Jake" wrote:

Thanks, now what if I want the number (10 in this case) to be variable based
on a referenced cell?

"Bob Phillips" wrote:

=AVERAGE(LARGE(A1:A100,{1,2,3,4,5,6,7,8,9,10}))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jake" wrote in message
...
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