Google Sheets MINIFS Function: Syntax, Examples & Tips

range:
The range of cells from which you want to find the minimum value based on the specified criteria.

criteria_range1:
The range of cells that you want to evaluate against the first criterion.

criterion1:
The condition or value that you want to apply to the first criteria range. This can be a number, text, expression, or a cell reference.

criteria_range2:
(Optional) The range of cells that you want to evaluate against the second criterion.

criterion2:
(Optional) The condition or value that you want to apply to the second criteria range. This can be a number, text, expression, or a cell reference.

...:
(Optional) Additional pairs of criteria ranges and criteria that you can specify to further refine the minimum value calculation.

What is a MINIFS?

The MINIFS function in Google Sheets is a useful tool that allows you to find the minimum value in a range based on one or more criteria. This function is particularly helpful when you want to analyze data and extract specific insights based on certain conditions. Unlike the traditional MIN function, which simply returns the smallest number in a range, MINIFS enables you to apply filters to your data.

In simpler terms, MINIFS helps you find the lowest value in a dataset that meets specific conditions you set.

A Practical Example

Imagine you are tracking the sales performance of different products over various months in a Google Sheets document:

Sales Table:

You want to find the minimum sales figure for ProductID 101 across all months.

MINIFS Formula

To achieve this, you would use the MINIFS function as follows:

=MINIFS(Sales!C:C, Sales!A:A, 101)

In this formula:

• Sales!C:C is the range where the function will look for the minimum sales value.
• Sales!A:A is the range that contains the ProductID.
• 101 is the criteria that specifies which ProductID you want to filter by.

Result of the Formula

When you apply the MINIFS formula to the Sales Table, the output would be:

500

This indicates that the minimum sales for ProductID 101 across all months is 500.

Why Use MINIFS?

MINIFS is beneficial because it allows for more targeted data analysis by enabling you to set specific criteria for your calculations. This function simplifies the process of finding minimum values in datasets with multiple conditions, making it easier to draw insights from your data.

Key Takeaways:

• MINIFS: A powerful function that finds the minimum value in a range based on specified criteria.
• Conditional Analysis: Allows for filtering data based on one or more conditions, enhancing data analysis capabilities.
• Simplicity: Provides a straightforward way to perform conditional calculations without complex formulas.
• Common Use Cases: Ideal for sales analysis, performance tracking, and any scenario where you need to find minimum values based on specific criteria.

MINIFS is an essential function for anyone working with data in Google Sheets, providing a powerful way to enhance data analysis and reporting capabilities.

Happy spreadsheeting!