Excel MINIFS Function

Summary

The Excel MINIFS function returns the smallest numeric value that meets one or more criteria in a range of values. MINIFS can be used with criteria based on dates, numbers, text, and other conditions. MINIFS supports logical operators (>,<><>,=) and wildcards (*,?) for partial matching.

Purpose

Get minimum value with criteria

Return value

Minimim value

Syntax

=MINIFS (min_range, range1, criteria1, [range2], [criteria2], ...)

Arguments

min_range - Range of values used to determine minimum.
range1 - The first range to evaluate.
criteria1 - The criteria to use on range1.
range2 - [optional] The second range to evaluate.
criteria2 - [optional] The criteria to use on range2.

Usage notes

In the example shown, the formula in H7 is:

=MINIFS(D3:D15,C3:C15,"F")

Criteria range(s) must be the same size and shape as the min_range.
The MINIFS function was introduced in Excel 2016.
In earlier versions of Excel you can use an array formula based on MIN and IF to find minimum values with criteria.