The `MINIFS` function in Excel is used to find the minimum value in a range that meets one or more specified criteria. Here’s how you can use the `MINIFS` function:
Syntax
MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
- min_range: The range of cells from which you want to find the minimum value. This is the range that contains the numbers you want to evaluate.
- criteria_range1: The range of cells that you want to apply the first criteria against.
- criteria1: The criteria you want to apply to `criteria_range1`. This can be a number, expression, cell reference, or text that defines what cells will be evaluated.
- [criteria_range2, criteria2], …: (Optional) Additional pairs of ranges and associated criteria. You can specify multiple criteria ranges and criteria.
Example
Imagine you have the following dataset in Excel:
| A | B | C |
|——–|———–|———–|
| Date | Product | Sales |
| 01-Jan | Apples | 10 |
| 02-Jan | Oranges | 15 |
| 03-Jan | Apples | 7 |
| 04-Jan | Apples | 20 |
| 05-Jan | Oranges | 30 |
You want to find the minimum sales for “Apples”. You can use the `MINIFS` function like this:
=MINIFS(C2:C6, B2:B6, "Apples")
This formula will return `7`, which is the minimum sales figure for “Apples”.
Tips
- All criteria ranges must be the same size as the `min_range`.
- Criteria can include wildcards like `?` for a single character or `*` for a series of characters, useful when working with text.
- You can use comparison operators like `”>2″`, `”<10″`, or `”<>5″` within the criteria.
By following these guidelines, you should be able to effectively use the `MINIFS` function to analyze data in Excel.
Unlock Your Potential
Excel
Access
Power BI
