How to use MINIFS to get a Minimum by One Criteria
MINIFS function can be used to find the minimum value based on a single criterion. If you want to use the MINIFS function to find the minimum value based on a single criterion, you just need to specify a single criterion. MINIFS works fine with single or multiple criteria.
Here’s the syntax for using MINIFS with a single criterion:
=MINIFS(min_range, criteria_range1, criteria1)
Below is an example dataset that contains products quantity sold in different city monthly. Suppose we need to find the minimum value of “Green Tea” sold.
The formula for this condition can be written in three different ways:
1. =MINIFS(D2:D14,A2:A14,”Green Tea”)
- D2:D14 is the min_range, where we want to find the minimum quantity sold.
- A2:A14 is the first criteria range, which checks the “Product” column for “Green Tea.”
- “Green Tea” is the first criteria, specifying the Green Tea Product.
The MINIFS function will return the minimum quantity sold that meets the criteria, which in this example would be 349.
2. =MINIFS(D2:D14,A2:A14,F4)
- D2:D14 is the min_range, where we want to find the minimum quantity sold.
- A2:A14 is the first criteria range, which checks the “Product” column for “Green Tea.”
- F4 is the first criteria, specifying the Green Tea Product.
The MINIFS function will return the minimum quantity sold that meets the criteria, which in this example would be 349.
3. =MINIFS(D2:D14,A2:A14,A2)
- D2:D14 is the min_range, where we want to find the minimum quantity sold.
- A2:A14 is the first criteria range, which checks the “Product” column for “Green Tea.”
- A2 is the first criteria, specifying the Green Tea Product.
The MINIFS function will return the minimum quantity sold that meets the criteria, which in this example would be 349.
How to use MINIFS function in Microsoft Excel
The MINIFS function in Excel is a powerful tool for filtering and analyzing data. It allows you to find the smallest numeric value in a range of cells that meet one or more specified requirements. This can be useful for a variety of tasks, such as finding the lowest price for a product in a specific category, finding the shortest delivery time for a product, finding the highest test score for a student in a particular class, or finding the lowest employee salary in a department.
Contact Us