The AVERAGEIF function returns the average of cell values that are valid for a given condition.
Formula in cell D3:
Excel Function Syntax
range, criteria, [ average_range]) Arguments
range Required. One or more cells to average, including numbers or names, arrays, or references that contain numbers.
criteria Required. A cell reference, expression or text that determines which values to be averaged.
Optional. Cells to average. If not entered,
range is used.
Boolean values TRUE or FALSE are excluded in the calculation.
An empty cell in argument
average_range is excluded.
A blank or text value in argument range is not valid, the function returns #DIV0!.
If a condition in argument average_range is empty is the same as 0 (zero).
The AVERAGEIF function returns #DIV0! if no values match the criteria.
It is possible to use wildcard characters like (?) question mark or (*) asterisk.
(?) question mark matches any single character.
(*) asterisk matches any sequence of characters.
Use a tilde (~) before to escape the wildcard characters meaning finding the actual question mark or asterisk.
The following article has a formula that contains the AVERAGEIF function.
The AVERAGEIF function function is one of many functions in the 'Statistical' category.