# 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(min_range, range1, critera1, [range2, criteria2], ...)`

## Arguments

This function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *min\_range* | [required] Refers to the range of cells in which minimum will be calculated |
| *range1* | [required] Refers to the set of cells to be calculated based on criteria |
| *criteria1* | [required] 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.

## Examples

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