Using the Excel MINIFS Function
SummaryThe 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 BreakdownMin Range
Required. Range of cells from which the minimum value will be found.
Criteria Range 1
Required. Cells to evaluate with a given criteria.
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.
Optional. Additional criteria to define which cell will be evaluated as the minimum.
Usage NotesMINIFS 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.