How to Use AverageIf Function in Excel
The syntax for the Microsoft Excel AVERAGEIF function is:
AVERAGEIF( range, criteria, [average_range] )
Parameters or Arguments
range is the range of cells that you want to apply the criteria against.
criteria is used to determine which cells to average.
average_range is optional. It is the cells to average. If average_range is omitted, AVERAGEIF uses range as the value for this parameter.
The AVERAGEIF function can be used in the following versions of Microsoft Excel:
- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007
Type of Excel Function
The AVERAGEIF function can be used in Microsoft Excel as the following type of function:
- Worksheet function (WS)
Example (as Worksheet Function)
Let’s look at some Excel AVERAGEIF function examples and explore how to use the AVERAGEIF function as a worksheet function in Microsoft Excel:
Based on the spreadsheet above, the following Excel AVERAGEIF examples would return:
|=AVERAGEIF(A2:A7, 2012, B2:B7)||would return 8.2|
|=AVERAGEIF(A:A, 2011, B:B)||would return 10|
|=AVERAGEIF(A2:A7, “>=2012”, B2:B7)||would return 7.8|
|=AVERAGEIF(A2:A7, “<2013”)||would return 2011.2|