MINIFS

Returns the minimum value from a range that meets multiple criteria.

Syntax

MINIFS(min_range, criteria_range1, criterion1, [criteria_range_n], [criterion_n])

Arguments

Argument	Description	Required
`min_range`	The range to find minimum value from.	Required
`criteria_range1`	First range to evaluate criteria against.	Required
`criterion1`	The criteria is the formula that has access to the special `CELL` keyword. The formula will be evaluated for each cell in the range.	Required
`criteria_range_n`	Additional range to evaluate criteria against.	Optional
`criterion_n`	Additional criteria that will be evaluated.	Optional

Examples

Find minimum with single criteria

=MINIFS(A1:A5, B1:B5, CELL = "Active")

Result ⇒ 75

	A	B
1	100	Active
2	200	Active
3	150	Inactive
4	75	Active
5	300	Active

Find minimum with multiple criteria

=MINIFS(A1:A5, B1:B5, CELL = "Active", C1:C5, CELL > 55)

Result ⇒ 200

	A	B	C
1	100	Active	50
2	200	Active	60
3	150	Inactive	40
4	75	Active	30
5	300	Active	70

Find minimum with numeric criteria

=MINIFS(A1:A4, B1:B4, CELL > 100)

Result ⇒ 200

	A	B
1	100	50
2	200	150
3	75	80
4	300	200

Related Functions

Other Statistical functions:

AVEDEV - Returns the average of the absolute deviations of data points from their mean
AVERAGE - Returns the average of given arguments. Text is ignored.
CORREL - Returns the correlation coefficient between two data sets
COUNT - Returns the count of numeric values in a dataset.
COUNTA - Returns the count of values in a list of arguments including text, logical values, error values, and empty text.
COUNTIF - Returns the count of cells that meet a specified criteria
COUNTIFS - Returns the count of criteria_ranges based on the given criterions.
FORECAST - Calculates, or predicts, a future value by using existing values
LARGE - Returns the k-th largest value in a data set
MAX - Returns the largest number from the provided arguments
MEDIAN - Returns the median of the given numbers
MIN - Returns the smallest number from the provided arguments
MODE - Returns the most frequently occurring value in a data set
PERCENTILE - Returns the k-th percentile of values in a range
PERCENTRANK - Returns the rank of a value in a dataset as a percentage (0 to 1) of the dataset
RANK - Returns the rank of a number from the list of other numeric values
SMALL - Returns the k-th smallest value in a data set
STDEV - Returns the estimated standard deviation based on a sample
STDEVP - Calculates standard deviation based on the entire population
SUMIF - Returns the sum of a range depending on criteria
SUMPRODUCT - Returns the sum of products for a list of arguments
VAR - Returns the estimated variance for a sample of data
VARP - Calculates variance based on the entire population

← Back to Formula Reference