Author: Oscar Cronquist Article last updated on April 18, 2018

The MINIFS function calculates the smallest value based on a given set of criteria.

Formula in cell E3:

=MINIFS(C3:C10,B3:B10,"A")

The formula in cell E3 checks if values in column B are equal to "A". If TRUE, corresponding values in column C are evaluated and the minimum value is then returned to cell E3.

Excel Function Syntax

MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Arguments

min_range Required. A cell reference pointing to the numbers.
criteria_range1 Required. Cells to evaluate based on the criteria.
criteria1 Required. Criteria in the form of a number, expression, or text.
[criteria_range2] Optional. Up to 126 additional arguments.
[criteria2] Optional. Up to 126 additional arguments.

Comments

The MINIFS function returns #VALUE error if the cell range size of the min_range, criteria_range and criteria is not the same.