## How to use the MINIFS function

*Article updated on April 18, 2018*

The MINIFS function calculates the smallest value based on a given set of criteria.

Formula in cell E3:

The formula in cell E3 checks if values in column B are equal to "A". If TRUE, corresponding values in column C are evaluated and the minimum value is then returned to cell E3.

### Excel Function Syntax

MINIFS(*min_range*, *criteria_range1*, *criteria1*, [*criteria_range2*, *criteria2*], ...)

### Arguments

min_range |
Required. A cell reference pointing to the numbers. |

criteria_range1 |
Required. Cells to evaluate based on the criteria. |

criteria1 |
Required. Criteria in the form of a number, expression, or text. |

[criteria_range2] |
Optional. Up to 126 additional arguments. |

[criteria2] |
Optional. Up to 126 additional arguments. |

### Comments

The MINIFS function returns #VALUE error if the cell range size of the min_range, criteria_range and criteria is **not** the same.

### Articles with the 'MINIFS' Function

The following 3 articles have formulas that contain the MINIFS function.

### Functions in 'Statistical'

The MINIFS function function is one of many functions in the 'Statistical' category.