Check Sheet Logo
Check Sheet

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:

=MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], ...)
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.

Related Formulas

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.

Learn More

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