Here, we will learn how to use the Excel math functions: AVERAGE, AVERAGEIF and AVERAGEIFS.
AVERAGE function
The Excel AVERAGE function returns the average of numbers supplied. The function can be found in all the versions of Excel. AVERAGE takes the arguments like this: (number1, [number2], [number3],…), of which number1 is required, and thereafter subsequent optional arguments.
AVERAGEIF function
The Excel AVERAGEIF function returns the average of cells that meet a single condition. The function can be found in all the versions of Excel. AVERAGEIF takes the arguments like this: (range, criteria, [average_range]), of which range and criteria are required and average_range is optional.
AVERAGEIFS function
The Excel AVERAGEIFS function returns the average of cells that meet multiple conditions. The function can be found in all the versions of Excel. AVERAGEIFS takes the arguments like this: (average_range, range1, criteria1, [range2], [criteria2],...), of which average_range and a pair of range and criteria are required and thereafter subsequent pair of optional arguments of range and criteria.
You have successfully learnt how to use the Excel math functions: AVERAGE, AVERAGEIF and AVERAGEIFS.
