Returns the average of the specified arguments.
Syntax
 Copy Code
|
|---|
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
Copy Code
|
|---|
=AVERAGEIF(A1:A5,"<18000") |
See Also
Function Reference
AVERAGE Function
SUM Function
COUNT Function