The Excel MINIFS Function


The Excel MINIFS function is a new function, introduced in Excel 365 and 2019. This function returns the minimum value from a given range.
In this article, we will learn how to use the MINIFS function in Excel.

Syntax of MINIFS Function

=MINIFS(min_range,criteria_range1,criteria1,...)

Min_range1: It is the numeric range that contains the minimum value.

Criteria_range1: It is the criteria range that you want to filter before getting the minimum value.

Criteria1: It is the criteria or the filter that you want to put on criteria_range before getting the minimum value.

You can have multiple pairs of criteria_range and criteria.
Let’s understand the MINIFS function with an example.
Example of MINIFS Function
So, here I have a table of some data. The first column contains the numeric values. Second column contains the Region and the third column has the department.

The task is to tell the min value from the first range for each region.

The formula for getting maximum value from "East" region will be:

=MINIFS(A2:A16,B2:B16,"East")

It will return 29.
Here we have given hardcoded criteria, but we can also give reference of the criteria to make it dynamic.

=MINIFS($A$2:$A$16,$B$2:$B$16,E2)

Here we have used absolute ranges to lock the min_range and criteria_range.
You can put more than 1 criteria in MINIFS function. For example, if I want to get minumum value from IT department of SOUTH region then the formula will be:

=MINIFS(A2:A16,C2:C16,"IT",B2:B16,"SOUTH")

This will return 36 as per above data. If we put "Accounts" in place of IT, the MINIFS will return 82.

So yeah guys, this was a small introduction to the MINIFS function of Excel 365 and 2019. I hope it was helpful. If you have any doubts regarding this article or any other excel topic, ask in the comments section below.

Related Article 

Calculate minimum if condition match in Excel 2016 | To calculate the minimum value with a condition in Excel 2016 and older versions, use this formula. Using the MIN and IF function together we can get a conditional minimum output.

Excel 2019/365 Functions:

How to Use The Excel UNIQUE Function | The UNIQUE function returns the Unique values from the given array.

The SORT Function in Excel | The SORT function returns the sorted form of the supplied array.

How to Use Excel SORTBY Function | The SORTBY function sorts a given range by a different specified range. Sorting range does not need to be part of the table.

How to Use The Excel FILTER Function | The FILTER function returns all matched values of given criteria and spills the result into adjacent cells.

The SEQUENCE Function in Excel | The SEQUENCE function returns a series of sequential numbers. It is a dynamic array formula.

Popular Articles:

50 Excel Shortcuts to Increase Your Productivity | Get faster at your task. These 50 shortcuts will make you work even faster on Excel.

How to use the VLOOKUP Function in Excel | This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets.

How to use the COUNTIF function in Excel 2016 | Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.

How to use the SUMIF Function in Excel | This is another dashboard essential function. This helps you sum up values on specific conditions.

 

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.