MAXIFS
Returns the maximum value of all cells which meet multiple criteria.
Syntax
=MAXIFS(MaxRange, CriterionRange1, Criterion1, [CriterionRange2, Criterion2], ...)
Arguments
| Name | Description |
|---|---|
| MaxRange | Cell-range to determine maximum value of. |
| CriterionRange1 | The cell-range which is checked against the criterion. |
| Criterion1 | The criterion each cell of CriterionRange1 has to fulfill. |
| CriterionRange2,... | Optional. Additional cell-range which is checked against next criterion. |
| Criterion2,... | Optional. Additional criterion each cell of CriterionRange2 has to fulfill. |
Return Value
The maximum of all cell values which meet all specified criteria.
Example
| A | B | C | D | |
| 1 | 89 | 1 | a | 1 |
| 2 | 93 | 2 | b | 2 |
| 3 | 96 | 2 | a | 3 |
| 4 | 85 | 3 | b | 4 |
| 5 | 91 | 1 | b | 5 |
| 6 | 88 | 1 | a | 6 |
| Function | Result | Comment |
|---|---|---|
| MAXIFS(A1:A6, B1:B6, 1) | 91 | Maximum value of cells which have 1 in their B-column. |
| MAXIFS(A1:A6, C1:C6, "b", D6:D6, ">=2") | 93 | Maximum value of all cells which have "b" in their C-column and its D-column value is greater or equal 2. |
| MAXIFS(A1:A6, B1:B6, ">4") | 0 | No cell fulfills given criterion. |
| MAXIFS(A1:A6, B1:D7, ">4") | #VALUE! | MaxRange and CriteriaRange have different height and/or with. |