# MAXIFS

Formulas / MAXIFS
Find the maximum value in a range using criteria.
`MAXIFS(max_range, criteria_range1, criteria1, criteria_range2, criteria2, ...)`
• max_range - the actual range of cells to determine the maximum in
• criteria_range1 - the set of cells to be evaluated with the criteria
• criteria1 - the criteria that defines which cells to evaluate as maximum
• criteria_range2, ... [OPTIONAL] - additional ranges and their associated criteria

## Examples

• `=MAXIFS(D5:D16,C5:C16,"F")`

The MAXIFS function can be used to find the maximum value in a range of cells, when one or more criteria are true. For example, this returns the maximum value in the range D5:D16 where the corresponding cells in C5:C16 are equal to "F" (93).

• `=MAXIFS(D5:D16,C5:C16,"M")`

The MAXIFS function can also be used to find the maximum value in a range of cells when the criteria is a string. For example, this returns the maximum value in the range D5:D16 where the corresponding cells in C5:C16 are equal to "M" (83).

• `=MAXIFS(A1:A100,B1:B100,">50")`

The MAXIFS function can also be used to find the maximum value in a range of cells when the criteria is a comparison operator. For example, this returns the maximum value in the range A1:A100 when the corresponding cells in B1:B100 are greater than or equal to 50.

## Summary

The MAXIFS function is a powerful tool that allows users to quickly find the maximum value in a set of cells when given a set of conditions or criteria. It works on both Windows and Mac systems.

• MAXIFS is a Sourcetable function that requires a cell range for range arguments.