# 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](/content/docs/formulas/avedev.html) \- Returns the average of the absolute deviations of data points from their mean
- [AVERAGE](/content/docs/formulas/average.html) \- Returns the average of given arguments. Text is ignored.
- [CORREL](/content/docs/formulas/correl.html) \- Returns the correlation coefficient between two data sets
- [COUNT](/content/docs/formulas/count.html) \- Returns the count of numeric values in a dataset.
- [COUNTA](/content/docs/formulas/counta.html) \- Returns the count of values in a list of arguments including text, logical values, error values, and empty text.
- [COUNTIF](/content/docs/formulas/countif.html) \- Returns the count of cells that meet a specified criteria
- [COUNTIFS](/content/docs/formulas/countifs.html) \- Returns the count of criteria_ranges based on the given criterions.
- [FORECAST](/content/docs/formulas/forecast.html) \- Calculates, or predicts, a future value by using existing values
- [LARGE](/content/docs/formulas/large.html) \- Returns the k-th largest value in a data set
- [MAX](/content/docs/formulas/max.html) \- Returns the largest number from the provided arguments
- [MEDIAN](/content/docs/formulas/median.html) \- Returns the median of the given numbers
- [MIN](/content/docs/formulas/min.html) \- Returns the smallest number from the provided arguments
- [MODE](/content/docs/formulas/mode.html) \- Returns the most frequently occurring value in a data set
- [PERCENTILE](/content/docs/formulas/percentile.html) \- Returns the k-th percentile of values in a range
- [PERCENTRANK](/content/docs/formulas/percentrank.html) \- Returns the rank of a value in a dataset as a percentage (0 to 1) of the dataset
- [RANK](/content/docs/formulas/rank.html) \- Returns the rank of a number from the list of other numeric values
- [SMALL](/content/docs/formulas/small.html) \- Returns the k-th smallest value in a data set
- [STDEV](/content/docs/formulas/stdev.html) \- Returns the estimated standard deviation based on a sample
- [STDEVP](/content/docs/formulas/stdevp.html) \- Calculates standard deviation based on the entire population
- [SUMIF](/content/docs/formulas/sumif.html) \- Returns the sum of a range depending on criteria
- [SUMPRODUCT](/content/docs/formulas/sumproduct.html) \- Returns the sum of products for a list of arguments
- [VAR](/content/docs/formulas/var.html) \- Returns the estimated variance for a sample of data
- [VARP](/content/docs/formulas/varp.html) \- Calculates variance based on the entire population