# 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.

## Frequently Asked Questions

What is the MAXIFS Function?
The MAXIFS function is used to return the maximum value from a set of cells based on a set of conditions or criteria.
Is the MAXIFS Function Available on Both Windows and Mac?
Yes, the MAXIFS Function is available on both Windows and Mac with either Office 2019 or a Microsoft 365 subscription.
What Are the Requirements to Use the MAXIFS Function?
The MAXIFS function requires at least Office 2019 or a Microsoft 365 subscription in order to use it.
What Are the Requirements for the Arguments in the MAXIFS Function?
• The max_range and criteria_range1 arguments must be the same size and shape.