AVERAGEIFS
Averages values in average_range where ALL criteria match. Returns #DIV/0! if no rows match.
| Category | Aggregate |
| Syntax | AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) |
Parameters
| Parameter | Required | Description |
|---|---|---|
average_range | Required | The range of cells to average. |
criteria_range1 | Required | The first range to evaluate against criteria1. |
criteria1 | Required | The criteria to apply to criteria_range1. |
criteria_range2 | Optional | Additional range to evaluate. |
criteria2 | Optional | Additional criteria. |
Example
AVERAGEIFS(range, criteria)
Auto-generated from the EngCanvas function registry.