Statistical - AVERAGEIF Function

Description

The AVERAGEIF function returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.

AVERAGEIF (range, criteria, [average_range])

Argument	Description	Required/ Optional
Range	One or more cells to average, including numbers or names, arrays, or references that contain numbers.	Required
Criteria	The criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged.	Required
Average_range	The actual set of cells to average. If omitted, range is used.	Optional

Cells in range that contain TRUE or FALSE are ignored.
If a cell in average_range is an empty cell, AVERAGEIF ignores it.
If a cell in criteria is empty, AVERAGEIF treats it as a 0 value.
You can use the wildcard characters, question mark (?) and asterisk (*), in criteria. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
Average_range does not have to be the same size and shape as range. The actual cells that are averaged are determined by using the top, left cell in average_range as the beginning cell, and then including cells that correspond in size and shape to range.
If range is a blank or text value, AVERAGEIF returns the #DIV0! error value.
If no cells in the range meet the criteria, AVERAGEIF returns the #DIV/0! error value.
If values to be averaged are all non-numeric, AVERAGEIF returns the #DIV0! error value
If the criteria argument is a text string with length greater than 255 characters, AVERAGEIF returns the #VALUE! error value.

Excel 2007, Excel 2010, Excel 2013, Excel 2016

advanced_excel_statistical_functions.htm