MAXIFS function in Excel returns the Maximum value from the set of supplied numbers that meets some specific conditions. The MAXIFS function in Excel supports logical operators (>,<,<>,=) and wildcards (*,?) for pattern matching.
Wild cards in MAXIFS Function
- ? – matches any single character
- * – matches any sequence of characters
Example:
The condition “A?e” will match all cells containing a text string beginning with “A” and ending in “e” and only one character in between i.e. A_e.
The condition “A*e” will match all cells containing a text string beginning with “A” and ending in “e” with multiple character(n) in between i.e. A_______e.
Syntax of MAXIFS Function in Excel:
MAXIFS( max_range, criteria_range1, criteria1, [criteria_range2, criteria2], … )
- max_range – Range of numeric values from which you want to find the maximum value if the conditions are satisfied.
- criteria_range1 – An array of values to be tested against criteria1.
- criteria1 – The condition to be tested against the values in criteria_range1
Example of MAXIFS Function in Excel
Formula
- First two examples states the use of logical operation in MAXIFS function with conditions.
- Last two examples states the use of wildcards in MAXIFS function with two conditions.
So the result will be like
Result
Note: MAXIFS Function is available only from Microsoft Excel 2016 onwards