The Excel MINIFS function returns the smallest number in a range that meets one or more conditions — a conditional MIN with no array formula required.
Syntax
| Argument | Description | |
|---|---|---|
min_range | Required | The range of cells to find the minimum from. |
criteria_range1 | Required | The first range to test against criteria1. Must be the same size as min_range. |
criteria1 | Required | The condition defining which cells in min_range to consider — a number, text, or expression like ">100". |
criteria_range2, criteria2, ... | Optional | Up to 126 additional range/criteria pairs. All conditions must be met (AND logic). |
How to use it
MINIFS is the mirror image of MAXIFS: it returns the smallest value in min_range across the rows where every criteria range matches. Each criteria range must be the same size as min_range.
Operators and references work the same as in SUMIFS: ">100", "<>0", or ">"&F1. A common pattern is filtering out zeros with ">0" so an empty/zero row doesn't masquerade as the minimum.
| A | B | C | |
|---|---|---|---|
| 1 | Region | Year | Sale |
| 2 | East | 2024 | 1200 |
| 3 | West | 2024 | 900 |
| 4 | East | 2025 | 1500 |
| 5 | =MINIFS(C2:C4,A2:A4,"East") | → 1200 | |
No match returns 0. Like MAXIFS, MINIFS returns 0 when no rows satisfy the criteria. If zero is a meaningful value in your data, verify the match count with COUNTIFS first.
Try it: interactive demo
Pick a MINIFS example to see the formula and its result.
Practice workbook
Frequently asked questions
What does MINIFS return if no rows match?
0, not an error. Because 0 might also be a genuine minimum in your data, confirm there are matching rows (e.g. with COUNTIFS) before trusting a 0.How do I get the lowest value above zero?
=MINIFS(C2:C100, C2:C100, ">0"). This ignores zero and blank entries when finding the minimum.Can MINIFS take multiple conditions?
criteria_range, criteria pairs. Every condition must be true for a row to qualify (AND logic).MINIFS vs an array MIN(IF) formula?
=MIN(IF(A2:A100="East",C2:C100)) entered with Ctrl+Shift+Enter. MINIFS does it natively and supports several conditions at once.Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class