## Purpose

## Return value

## Arguments

*min_range*- Range of values used to determine minimum.*range1*- The first range to evaluate.*criteria1*- The criteria to use on range1.*range2*- [optional] The second range to evaluate.*criteria2*- [optional] The criteria to use on range2.

## Syntax

## Usage notes

The MINIFS function returns the smallest numeric value that meets one or more supplied criteria. The MINIFS function can apply criteria to dates, numbers, and text. MINIFS supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

The MINIFS function takes three required arguments: *min_range*, *range1*, and *criteria1*. With these three arguments, MINIFS returns the minimum number in *min_range* where corresponding cells in *range1* meet the condition set by *criteria1*. Additional conditions are applied using range/criteria pairs. The second condition is defined by *range2* and *criteria2*, the third condition is *range3* and *criteria3*, and so on. MINIFS can handle up to 126 range/criteria pairs.

When using MINIFS, keep the following in mind:

- Each new condition requires a separate
*range*and*criteria*. - To be included in the final result, all conditions must be TRUE.
- If no cells meet criteria, MINIFS will return zero (0).
- MINIFS will automatically ignore empty cells that meet criteria.
- MINIFS
*requires*a cell range for range arguments; you can't use an array.

### Criteria

The MINIFS function supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching. Because MINIFS is in a group of eight functions that split logical criteria into two parts, the syntax is a bit tricky. Each condition requires a separate *range* and *criteria*, and operators need to be enclosed in double quotes (""). The table below shows some common examples:

Target | Criteria |
---|---|

Cells greater than 75 | ">75" |

Cells equal to 100 | 100 or "100" |

Cells less than or equal to 100 | "<=100" |

Cells equal to "Red" | "red" |

Cells not equal to "Red" | "<>red" |

Cells that are blank "" | "" |

Cells that are not blank |
"<>" |

Cells that begin with "X" | "x*" |

Cells less than A1 | "<"&A1 |

Cells less than today | "<"&TODAY() |

Notice the last two examples use concatenation with the ampersand (&) character. When a *criteria* argument includes a value from another cell, or the result of a formula, logical operators like "<" must be joined with concatenation. This is because Excel needs to evaluate cell references and formulas first to get a value before that value can be joined to an operator.

### Basic example

In the worksheet shown above, the formulas in G5 and G6 are:

```
=MINIFS(D5:D16,C5:C16,"F") // returns 72
=MINIFS(D5:D16,C5:C16,"M") // returns 64
```

In the first formula, MINIFS returns the minimum value in D5:D16 where C5:C16 is equal to "F" (72). In the second formula, MINIFS returns the minimum value in D5:D16 where C5:C16 is equal to "M" (64).

### Two criteria

In the example below, the MINIFS function is used with two criteria, one for Gender and one for Group. Note conditions are added in range/criteria pairs. The range E5:E16 is paired with the condition "B".

The formulas in H5:I6 are:

```
=MINIFS(D5:D16,C5:C16,"F",E5:E16,"A") // returns 72
=MINIFS(D5:D16,C5:C16,"F",E5:E16,"B") // returns 83
=MINIFS(D5:D16,C5:C16,"M",E5:E16,"A") // returns 65
=MINIFS(D5:D16,C5:C16,"M",E5:E16,"B") // returns 64
```

### Other criteria

To return the minimum value in A1:A100 when cells in B1:B100 are greater than 50:

```
=MINIFS(A1:A100,B1:B100,">50")
```

To get the minimum value in A1:A100 when cells in B1:B100 are less than or equal to 100, and cells in C1:C100 are greater than zero:

```
=MINIFS(A1:A100,B1:B100,"<=100",C1:C100,">0")
```

### Not equal to

To construct "not equal to" criteria, use the "<>" operator surrounded by double quotes (""). For example, to return the minimum value in A1:A100 when cells in B1:B100 are not equal to "red":

```
=MINIFS(A1:A100,B1:B100,"<>red")
```

### Value from another cell

When using a value from another cell in a condition, the cell reference must be concatenated to the operator. For example, to return the minimum value in A1:A100 when cells in B1:B100 are greater than the value in C1:

```
=MINIFS(A1:A100,B1:B100,">"&C1)
```

Notice the greater than operator (>) is enclosed in quotes (""), but the cell reference (C1) is not.

### Wildcards

The wildcard characters question mark (?), asterisk(*), or tilde (~) can be used in *criteria*. A question mark (?) matches any one character, and an asterisk (*) matches zero or more characters. For example, to return the minimum value in A1:A100 when cells in B1:B100 begin with "a":

```
=MINIFS(A1:A100,B1:B100,"a*")
```

The tilde (~) is an escape character to allow you to find literal wildcards. For example, to match a literal question mark (?), asterisk(*), or tilde (~), add a tilde in front of the wildcard (i.e. ~?, ~*, ~~).

### Notes

- Conditions are applied using range/criteria pairs.
- MINIFS will return a #VALUE error if any criteria range is not the same size as
*min_range.* - If no criteria match, MINIFS will return zero (0).
- MINIFS ignores empty cells that meet criteria.