Function 4 – AVERAGE

To calculate the average of a group of numbers, use the AVERAGE function (no rocket science here). The formula below calculates the average of the top 3 numbers in the range A1:A6.

Explanation: the LARGE function returns the array constant {20,15,10}. This array constant is used as an argument for the AVERAGE function, giving a result of 15.