Google Sheets-functie

MINIFS

Returns the minimum value among cells specified by a given set of conditions or criteria.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

MINIFS(min_range, criteria_range1, criteria1, ...)

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.

Argumenten

min_rangevereistThe actual range of cells in which to determine the minimum value.
criteria_range1vereistThe range of cells to evaluate by the associated criteria.
criteria1vereistThe condition that defines which cells in criteria_range1 will be considered.

Voorbeelden

=MINIFS(B2:B10, A2:A10, "Electronics")

Resultaat: 150

Returns the minimum value in B2:B10 where the corresponding cell in A2:A10 is 'Electronics'.

Veelgestelde vragen

Can I use multiple criteria with MINIFS?

Yes, you can add additional criteria_range and criteria pairs as needed.

Gerelateerde functies

MIN MAXIFS AVERAGEIFS SUMIFS