MAXIFS
Returns the maximum value among cells that meet one or more criteria.
| Category | Aggregate |
| Syntax | MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) |
Parameters
| Parameter | Required | Description |
|---|---|---|
max_range | Required | The range of cells to find the maximum in. |
criteria_range1 | Required | The first range to evaluate. |
criteria1 | Required | The criteria to apply to criteria_range1. |
criteria_range2 | Optional | Additional range to evaluate. |
criteria2 | Optional | Criteria to apply to criteria_range2. |
Example
MAXIFS(range, criteria)
Auto-generated from the EngCanvas function registry.