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

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

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

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