Thursday, August 11, 2016

How to use AVERAGEIF Function (WS)

Description

The Microsoft Excel AVERAGEIF function returns the average (arithmetic mean) of all numbers in a range of cells, based on a given criteria.

Syntax

The syntax for the AVERAGEIF function in Microsoft Excel is:
AVERAGEIF( range, criteria, [average_range] )

Parameters or Arguments

range
The range of cells that you want to apply the criteria against.
criteria
The criteria used to determine which cells to average.
average_range
Optional. It is the cells to average. If average_range is omitted, it uses range as the value for this parameter.

Applies To

  • Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007

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:
Microsoft Excel
Based on the Excel spreadsheet above, the following AVERAGEIF examples would return:
=AVERAGEIF(A2:A7, 2012, B2:B7)
Result: 8.2

=AVERAGEIF(A:A, 2011, B:B)
Result: 10

=AVERAGEIF(A2:A7, ">=2012", B2:B7)
Result: 7.8

=AVERAGEIF(A2:A7, "<2013")
Result: 2011.2