minifs

Minimum value among cells meeting multiple criteria.

Syntax

v = minifs(min_range, criteria_range1, criteria1, ...)

Description

Returns the smallest value in min_range whose corresponding criteria_range_n cells all match criteria_n.

Example

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

See also

• min — Minimum value along a dimension, or elementwise minimum of two inputs.
• mina — Minimum value, treating text as 0 and TRUE as 1.
• maxifs — Maximum value among cells meeting multiple criteria.