Returns the minimum value among cells specified by a given set of conditions or criteria.
Syntaxe
MINIFS(min_range, criteria_range1, criteria1, ...)Arguments
min_rangeobligatoire
The actual range of cells in which to determine the minimum value.
criteria_range1obligatoire
The range of cells to evaluate by the associated criteria.
criteria1obligatoire
The condition that defines which cells in criteria_range1 will be considered.
The MINIFS function allows you to find the smallest value in a range based on one or more logical conditions. It is highly useful for filtering data sets to identify minimums within specific categories or date ranges.
=MINIFS(B2:B10, A2:A10, "Electronics")→150Returns the minimum value in B2:B10 where the corresponding cell in A2:A10 is 'Electronics'.
Select the target cell
Click on the cell where you want to display the result.
Enter the formula
Type =MINIFS( and select the range to find the minimum, followed by your criteria ranges and conditions.
Yes, you can add additional criteria_range and criteria pairs as needed.