MINIFS
TheMINIFS
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.
 How to use
MINIFS
formula?  Examples of using
MINIFS
formula MINIFS
formula not working? Similar formulas to
MINIFS
Usage
Use the MINIFS
formula with the syntax shown below, it has 3 required parameters and 2 optional parameters:
 range (required):
The range of cells to evaluate and return the minimum value from.  criteria_range1 (required):
The range of cells against which the first criterion should be tested.  criterion1 (required):
The criterion to be tested against the first criteria range.  criteria_range2 (optional):
An optional second range of cells against which the second criterion should be tested.  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 theMINIFS
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.