AVERAGEIF

Returns the average of the specified arguments.

Syntax

AVERAGEIF( Reference range, Criterion criteria, [Reference averageRange] ) → Number

Parameters

range

Required. One or more cells to average.

criteria

Required. A number or text value that defines which cells to average. For example, ">10", "products", "5".

averageRange

Optional. The actual cells to average. If omitted, range is used.

Remarks

The range arguments can be either numbers or cells, ranges, or arrays that contain numbers. Logical values, text, and empty cells are ignored. The specified arguments must contain at least one number that satisfies the criteria or the function will return the #DIV/0! error value.

Example

Formula

=AVERAGEIF(A1:A5,"<18000")

See Also

Function Reference
AVERAGE Function
SUM Function
COUNT Function