maxifs

Maximum value among cells meeting multiple criteria.

Syntax

v = maxifs(max_range, criteria_range1, criteria1, ...)

Description

Returns the largest value in max_range whose corresponding criteria_range_n cells all match criteria_n. Multiple criteria are combined with logical AND.

Example

maxifs(B1:B100, A1:A100, 'red')

See also

• max — Maximum value along a dimension, or elementwise maximum of two inputs.
• maxa — Maximum value, treating text as 0 and TRUE as 1.
• minifs — Minimum value among cells meeting multiple criteria.