How to use the MINIFS Function in Excel

Using the Excel MINIFS Function

Summary

The Excel MINIFS function returns the smallest numeric value in a range of values that meets a specific condition or criteria. MINIFS can be used with criteria that includes dates, numbers, text, and other conditions. The function supports logical operators (<, >, <>, =) and wildcard characters (? and *).

Use the MAXIFS function to find the largest value in a range of values based on specific criteria.

Syntax

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

Syntax Breakdown

Min Range
Required. Range of cells from which the minimum value will be found.

Criteria Range 1
Required. Cells to evaluate with a given criteria.

Criteria 1
Required. Criteria can be in the form of a number, date, expression, or text and defines which cells will be evaluated as the minimum. The criteria also works for MAXIFS, SUMIFS, and AVERAGEIFS.

Criteria Range 2
Optional. Additional cells to evaluate with a given criteria. The function can accept up to 126 range/criteria pairs.

Criteria 2
Optional. Additional criteria to define which cell will be evaluated as the minimum.

Usage Notes

MINIFS returns the smallest value that meets specific conditions from a range of values.

Criteria ranges must be the same size and shape as min_range, or the function returns the #VALUE! error.