Advanced Excel Statistical - MINIFS Function

Description

The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria. This function was added in Excel 2016.

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

Argument	Description	Required/ Optional
min_range	The actual range of cells in which the minimum will be determined.	Required
criteria_range1	Is the set of cells to evaluate with the criteria.	Required
criteria1	Is the criteria in the form of a number, expression, or text that defines which cells will be evaluated as minimum. The same set of criteria works for the MAXIFS, SUMIFS, and AVERAGEIFS Functions.	Required
criteria_range2, criteria2, ...	Additional ranges and their associated criteria. You can enter up to 126 range/criteria pairs.	Optional

The size and shape of the min_range and criteria_rangeN arguments must be the same, otherwise these functions return the #VALUE! Error.

Excel 2016

advanced_excel_statistical_functions.htm