Hi,

Your message header and message body are contradictory is it sum or average?

try this

=AVERAGE(LARGE(A1:A10,ROW(INDIRECT("1:6"))))

change average to sum for sum

Mike

"cellofellow" wrote:

I am trying to get an average of list, but if there are more than 6 numbers
in the list to only use the top 6 values. My first thought was some sort of
sum of top six then a count of numbers from the list (in case there are not 6
numbers in the list).
Any help is appreciated!