What is MINIFS function in Excel?
The MINIFS function is one of the Statistical functions of Excel.
It returns the minimum value among cells specified by a given set of conditions or criteria.
We can find this function in Statistical of insert function Tab.
How to use MINIFS function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select STATISTICAL category.
5. Select MINIFS function.
6. Then select ok.
7. In the function arguments Tab you will see MINIFS function.
8. Min_range: the cells in which to determine the minimum value.
9. Criteria_range1: is the range of cells you want to evaluate for the particular condition.
10. Criteria1: is the condition or criteria in the form of a number, expression, or text that defines which cells will be included when determining the minimum value.
11. Criteria_range2: is the range of cells you want to evaluate for the particular condition.
12. Criteria2: is the condition or criteria in the form of a number, expression, or text that defines which cells will be included when determining the minimum value.
13. You will see the results in the formula result section.
