AVERAGEIF
Averages cells that meet a criteria.
| Category | Aggregate |
| Syntax | AVERAGEIF(range, criteria, [average_range]) |
Parameters
| Parameter | Required | Description |
|---|---|---|
range | Required | The range of cells to evaluate against the criteria. |
criteria | Required | The criteria in the form of a number, expression, or text that defines which cells will be averaged. |
average_range | Optional | The actual cells to average. If omitted, the cells in range are averaged. |
Example
AVERAGEIF(A1:A10, "<>0") // Average non-zero values
Auto-generated from the EngCanvas function registry.