MAXIFS

Returns the largest numeric value in a range that meets one or more given conditions, supporting multiple criteria and ranges.

Syntax

MAXIFS(max_range, criteria_range1, criterion1,

[criteria_range2, criterion2]

)

max_range

The range of numbers from which the maximum value is calculated. For example: A1:A5.

criteria_range1

The range of conditional values to check against criterion1. Must be of the same size as sum_range. For example: B1:B5.

criterion1

The condition to apply to criteria_range1. For example: ">20".

[optional] criteria_range2

An additional range of conditional values to check against criterion2.

MAXIFS(A1:A5, B1:B5, "<=20") returns 12