# MINIFS

The `MINIFS` function returns the minimum value from a range of cells that meet the specified criteria. It is commonly used in statistical analysis when working with large datasets.

## Usage

Use the `MINIFS` formula with the syntax shown below, it has 3 required parameters and 2 optional parameters:

Parameters:
1. range (required):
The range of cells to evaluate and return the minimum value from.
2. criteria_range1 (required):
The range of cells against which the first criterion should be tested.
3. criterion1 (required):
The criterion to be tested against the first criteria range.
4. criteria_range2 (optional):
An optional second range of cells against which the second criterion should be tested.
5. criterion2 (optional):
An optional criterion to be tested against the second criteria range.

## Examples

Here are a few example use cases that explain how to use the `MINIFS` formula in Google Sheets.

### Finding the smallest value in a range that meets a specific criterion

You can use `MINIFS` to find the smallest value in a range of data that meets a specific criterion. For example, you might use it to find the smallest sales figure for a particular product.

### Finding the smallest value in a range that meets multiple criteria

You can use `MINIFS` to find the smallest value in a range of data that meets multiple criteria. For example, you might use it to find the smallest sales figure for a particular product in a specific region.

### Finding the earliest date in a range that meets a specific criterion

You can use `MINIFS` to find the earliest date in a range of data that meets a specific criterion. For example, you might use it to find the earliest date that a particular customer made a purchase.

## Common Mistakes

`MINIFS` not working? Here are some common mistakes people make when using the `MINIFS` Google Sheets Formula:

### Using the wrong range for the criteria

One common mistake when using MINIFS is using the wrong range for the criteria. Ensure that the criteria range and the range being searched are the same size and are aligned properly.

### Forgetting to include a criteria

Another mistake when using MINIFS is forgetting to include a criteria. Ensure that all criteria ranges and criteria are included in the formula.

### Using the incorrect syntax

Ensure that the syntax for the MINIFS formula is correct. Check that all ranges and criteria are separated by commas and enclosed in parentheses.

The following functions are similar to `MINIFS` or are often used with it in a formula:

• `MAXIFS`

The `MAXIFS` function returns the maximum numeric value from a range of cells that meet one or more specified conditions. It is commonly used to filter data and find the largest value that meets specific criteria. This function is only available in Google Sheets and is part of the Statistical functions.

• `AVERAGEIFS`

The `AVERAGEIFS` formula calculates the average of a range of cells that meet multiple criteria. It is most commonly used to find the average of a range of values that meet specific conditions. The formula takes one required argument (average_range) and any number of optional argument pairs (criteria_range, criterion).

• `SUMIFS`

The `SUMIFS` formula is a function in Google Sheets that adds the values in a specified range based on multiple criteria. It is most commonly used to sum data that meets specific criteria, such as summing sales for a particular month by region or summing expenses for a specific category and date range.

You can learn more about the `MINIFS` Google Sheets function on Google Support.