Sum, Count & Average

Excel formula for Max or min with a condition

Find the largest or smallest value that meets a criterion.

Copy this formula

=MAXIFS(C:C, A:A, "East")

How the formula works

MAXIFS returns the maximum of the values where the criteria match; MINIFS returns the minimum. Both accept multiple range/criteria pairs, like SUMIFS.

Examples

=MINIFS(C:C, A:A, "East", B:B, ">0")→45

Smallest positive value in the East region.

FAQ

What if I'm on Excel 2016?

MAXIFS/MINIFS need Excel 2019+. On older versions use an array MAX(IF(...)) entered with Ctrl+Shift+Enter.

Related formulas

Sum with multiple conditions Rank a list of values

Functions used

MAXIFS MINIFS

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free