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.
Formula

Output

Next >> HLookUp Function in Excel with example