Google Sheets Function

MAXIFS

Returns the maximum value among cells specified by a given set of conditions or criteria.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

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

The MAXIFS function allows you to find the largest value in a range based on one or more criteria. You can apply multiple conditions across different ranges, and only cells that meet all specified criteria are evaluated for the maximum value.

Arguments

max_rangerequiredThe actual range of cells in which to determine the maximum value.
criteria_range1requiredThe range of cells to evaluate by the associated criteria.
criteria1requiredThe condition that defines which cells in criteria_range1 will be considered.

Examples

=MAXIFS(C2:C10, A2:A10, "Sales", B2:B10, ">100")

Result: 500

Returns the maximum value from C2:C10 where column A is 'Sales' and column B is greater than 100.

FAQ

Can MAXIFS handle multiple criteria?

Yes, you can add up to 127 range/criteria pairs to the function.

Related functions

MINIFS SUMIFS COUNTIFS MAX