MAXIFS
Formulas / MAXIFSFind 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.
Need help with Formulas?
Frequently Asked Questions
What is the MAXIFS Function?
Is the MAXIFS Function Available on Both Windows and Mac?
What Are the Requirements to Use the MAXIFS Function?
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.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.