MAXIFS

When to use it

When should I use MAXIFS instead of MAX?

Use MAXIFS to find the largest value among only the rows that meet one or more conditions, such as the highest sale in the West region this quarter. Plain MAX ignores conditions and looks at every value.

What does MAXIFS return when no rows meet the conditions?

If no rows satisfy all the criteria, MAXIFS returns 0 rather than an error, so check your conditions if you unexpectedly see 0.

What is the argument order for MAXIFS?

It starts with the range to take the maximum of, then pairs of criteria range and criterion: MAXIFS(max_range, criteria_range1, criterion1, criteria_range2, criterion2, ...). MINIFS follows the same pattern for the smallest value.

Used in

finance · operations

Syntax

MAXIFS(max_range,criteria_range1,criteria1,...)