MINIFS
The MINIFS function returns the smallest numeric value in a range that meets multiple criteria.
Syntax 🔗
=MINIFS(Min_range, Criteria_range1, Criteria1, [Criteria_range2, Criteria2, ...])
Min_range | The range of cells containing numeric values from which you want to find the smallest value. |
Criteria_range1 | The range where you want to apply the first criteria. |
Criteria1 | The criteria that determines which cells in Criteria_range1 to include in the evaluation. |
Criteria_range2 (Optional) | Additional ranges and criteria that you can specify to further filter the data. |
About MINIFS 🔗
Use the MINIFS function to find the smallest numeric value in a range that satisfies multiple criteria. This function helps you identify the minimum value from a specified range based on conditions that must be met simultaneously. It's a practical tool for filtering data to locate the exact value you need in Excel.
Examples 🔗
Suppose you have a dataset with columns for sales amounts, regions, and product categories. To find the smallest sales value for products sold in the 'North' region within the 'Electronics' category, use the MINIFS formula: =MINIFS(Sales_column, Region_column, "North", Category_column, "Electronics")
Imagine a situation where you have a list of students' scores across different subjects. To find the lowest score for a student named 'Alice' in either Math or English, use the MINIFS function: =MINIFS(Scores_column, Student_column, "Alice", Subject_column, "Math", Subject_column, "English")
Notes 🔗
Ensure the ranges and criteria in the MINIFS function are correctly structured to extract the smallest value that meets all conditions. Organize your data and criteria properly to achieve the desired results without discrepancies. Use this function to efficiently handle complex filtering tasks and find the smallest relevant values from your dataset.
Questions 🔗
The MINIFS function allows you to specify multiple criteria based on which to find the smallest value, whereas the MIN function simply returns the smallest value from a given range without considering any criteria.
Can I use the MINIFS function with text criteria?Yes, you can use text criteria in the MINIFS function. The function is versatile and can handle various types of criteria, including text, numbers, logical values, and more.
Is it possible to combine MINIFS with other functions in Excel?Absolutely! You can combine the MINIFS function with other functions like SUMIFS, AVERAGEIFS, MAXIFS, etc., to create more advanced and customized calculations that suit your specific analytic needs.