AVERAGE

Use average features (no rocket science here to measure the average of a set of number). The formula below calculates the average in the range A1:A6 of the top 3 numbers.

Explanation: the array constant {20,15,10} is returned by the LARGE function. As an argument for the AVERAGE function, this array constant is used, giving a result of 15.