Funzione di Google Sheets

MINIFS

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

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

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.

Argomenti

min_rangeobbligatorioThe actual range of cells in which to determine the minimum value.
criteria_range1obbligatorioThe range of cells to evaluate by the associated criteria.
criteria1obbligatorioThe condition that defines which cells in criteria_range1 will be considered.

Esempi

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

Risultato: 150

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

Domande frequenti

Can I use multiple criteria with MINIFS?

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

Funzioni correlate

MIN MAXIFS AVERAGEIFS SUMIFS