Statistical
AVERAGEIF Function
Returns the average (arithmetic mean) of all the cells in a range that meet one criteria.
by
Charley Kyd, MBA Microsoft Excel MVP, 20052014
The Father of Spreadsheet Dashboard Reports

Syntax
AVERAGEIF(range, criteria, average_range)
 range Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers.
 criteria Required. The criteria in the form of a number, expression, cell reference, or text that defines which cells are averaged. For example, criteria can be expressed as 17, "17", ">17", "hats", or B4.
 average_range Optional. The actual set of cells to average. If omitted,
range is used.
Applies To
Excel 2007 and above
Remarks
The following examples illustrate the common exceptions and
limitations of this function.
Note that since the arguments for the AVERAGEIFS function are
different from this function, which can cause confusion. But
since the AVERAGEIFS function also can be limited to one
criteria, I recommend that you always use the AVERAGEIFS
function rather than this one.
Examples
You can
download this example workbook here,
along with all other example workbooks I've completed for this
Excel help area.
The average of sales values greater than 10.
The average of the two South values.
Empty cells and text values are ignored
An error is returned when no values meet the Criteria
You can use the "*"
wildcard character.
You can use the "?" wildcard charcter by itself, or in combination with the "*" character.
The average_range (specified as cell D3 in the third argument) expands automatically to fit the dimensions of the Areas range, specified in the first argument.
Other Help
