# MINIFS

## Content

This function returns the minimum value among the values in cells or the cell range provided the specified set of conditions or the criteria meets.

## Syntax

`MINIFS(max_range, range1, critera1, [range2, criteria2], ..)`

## Arguments

This function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *min\_range* | Refers to the range of cells in which minimum will be calculated |
| *range1* | Refers to the set of cells to be calculated based on criteria |
| *criteria1* | Refers to the criteria (in term of number, expression, or text) according to which cells will be calculated |
| *range2, criteria2...* | [Optional] Refers to the additional ranges and their corresponding criteria |

## Remarks

If the size and shape of *min\_range* and *rangeN (refers to range1,2,3,4,......N) arguments* is not same, this function will return the #VALUE! error.

If cells do not match with the specified criteria, this function will return 0.

## Data Types

Accepts either numeric data, expression, or text for all arguments. Returns numeric data.

## Examples

`MINIFS(A3:A7,B3:B7,23)` gives the result 0.

`MINIFS(A3:A7,B3:B7,325)` gives the result 325.