Excel MAXIFS Function
The Excel MAXIFS function returns the largest numeric value that meets one or more criteria in a range of values. MAXIFS can be used with criteria based on dates, numbers, text, and other conditions. MAXIFS supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.
- max_range - Range of values used to determine maximum.
- range1 - The first range to evaluate.
- criteria1 - The criteria to use on range1.
- range2 - [optional] The second range to evaluate.
- criteria2 - [optional] The criteria to use on range2.
MAXIFS is a new function, available in Office 365 and Excel 2019.
The MAXIFS function can be used to find a maximum value in data after applying one or more criteria. Conditions are applied using range/criteria pairs. MAXIFS can handle up to 126 range/criteria pairs. Each criteria range supplied must be the same size as the man_range.
In earlier versions of Excel you can use an array formula based on MAX and IF to find maximum values with criteria.
In the example shown, the formula in G7 is:
MAXIFS returns the maximum value in D3:D15 where C3:C15 is equal to "F".
- Criteria range(s) must be the same size as the max_range.
- MAXIFS will return a #VALUE error if a criteria range is not the same size as the min_range.