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. 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