Average, AverageA, AverageIF and AverageIFs Functions in Excel

Average

Function returns average of given range or numbers in excel as result. Average is a trick to find the arithmetic mean for the given values. In this article we will see how we can perform various Average functions available in excel.

Average Syntax

=AVERAGE(number1, [number1], …)

number1: a mandatory parameter, refers to a number, range, name, an Average function can take upto 255 arguments.

Formula

Output

AverageA Syntex

=AVERAGEA(value1, [value2], …)

value1: a mandatory parameter, first value is must and subsequent values are optional, it can take upto 255 values or range of cells as input. If value is is non-numeric and passed as TRUE or FALSE would be counted as 1 or 0.

Formula

Output

AverageIF Syntax

=AVERAGEIF(range, criteria, [average_range])

range: a mandatory parameter, refers to the range on which AVERAGEIF function will be executed.
criteria: a mandatory parameter, refers to value, based on that you would like to find average.
average_range: an optional parameter, refers to range over average will take place based on criteria parameter.

Formula

Output

AverageIFs Syntax

=AVERAGEIFS(average_range, criteria_range1, criteria1, …)

average_range: a mandatory parameter, refers to range that needs to be averaged.
criteria_range1: a mandatory parameter, refers to range in which match needs to be performed to perform average.
range1_criteria1: a mandatory parameter, refers to criteria which needs to be applied over criteria_range parameter.