MAXIFS Function in Excel – Get the Maximum value with conditions in Excel

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

MAXIFS Function in Excel 1

  • 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

MAXIFS Function in Excel 2

Note: MAXIFS Function is available only from Microsoft Excel 2016 onwards

previous-small MAXIFS Function in Excel                                                                                                                next_small MAXIFS Function in Excel