Function reference

MAXIFS in Excel & Google Sheets

MAXIFS is used in 1 formula pattern in this library. Browse worked examples below, or use the generator to build a custom variation for your specific data.

1 intermediateBuild a custom MAXIFS formula →

When to use MAXIFS

Find the highest sale in a specific region, the top score for one department, or the maximum order amount for a given customer.

Worked examples (1)

Math & Statisticsintermediate

Find the maximum value by criteria with MAXIFS

=MAXIFS(D2:D100,B2:B100,"East")

Open formula MAXIFS reference

Common errors with MAXIFS

MAXIFS returns 0 when no match is found

Unlike AVERAGEIFS, MAXIFS returns 0 (not an error) when no rows match. Use IF(MAXIFS(...)=0,"No match",MAXIFS(...)) to distinguish zero values from no match.

MAXIFS is not available

MAXIFS requires Excel 2019 or Excel 365. In older versions, use an array formula — =MAX(IF(B2:B100="East",D2:D100)) entered with Ctrl+Shift+Enter.

Frequently asked questions

Is there a MINIFS function as well?

Yes — MINIFS works identically to MAXIFS but returns the smallest matching value. Both functions were introduced in Excel 2019.

Need a custom variation?

Describe your specific MAXIFS problem and get a formula written for your exact data.

Open generator with MAXIFS