MINIFS returns the smallest value among rows that meet every supplied condition. If no row matches, it returns zero, so check the match count when zero is also a valid result.
MINIFS function syntax
=MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])- range: numeric values to minimize.
- criteria_range and criterion: matching range and test; repeat in pairs.
- All ranges must have matching dimensions.
Set up the example data
Enter this small dataset starting in A1. The first row contains headers. Keep the formula output separate from the input cells.
| Region | Amount | Quantity | Date |
|---|---|---|---|
| East | 250 | 15 | =DATE(2026,1,5) |
| West | 150 | 20 | =DATE(2026,1,10) |
| East | 320 | 8 | =DATE(2026,2,1) |
| North | 0 | 12 | =DATE(2026,2,5) |
| East | 410 | 25 | =DATE(2026,2,12) |
| West | 180 | 10 | =DATE(2026,3,1) |
Enter the DATE expressions as formulas, then apply a date format to those cells. They create actual dates rather than locale-dependent date text.
Find the minimum for a text label
Enter the formula in A10. East amounts are 250, 320 and 410, so the smallest is 250.
=MINIFS(B2:B7,A2:A7,"East")Result: 250.
Use a numeric threshold
This keeps rows with quantities above ten. North qualifies and has an actual amount of zero, so zero is a legitimate answer. Put comparison operators inside quotes.
=MINIFS(B2:B7,C2:C7,">10")Result: 0.
Require two conditions together
Additional pairs use AND logic. Only East rows with quantities above ten qualify. A threshold held in a cell can be joined to the operator with an ampersand.
=MINIFS(B2:B7,A2:A7,"East",C2:C7,">10")Result: 250.
Show a label when nothing matches
South does not appear. COUNTIF distinguishes that missing group from a group whose minimum is genuinely zero. For multiple conditions, use COUNTIFS with the same criteria as MINIFS.
=IF(COUNTIF(A2:A7,"South")=0,"No match",MINIFS(B2:B7,A2:A7,"South"))Result: No match.
Match the beginning of a label
The asterisk matches any following characters. Both West rows qualify and the minimum is 150. A question mark matches one character; a tilde escapes a literal wildcard.
=MINIFS(B2:B7,A2:A7,"W*")Result: 150.
Exclude zero amounts
Testing the amount range itself keeps only positive amounts. This also excludes negative amounts; use a different criterion if negative values belong in your result.
=MINIFS(B2:B7,B2:B7,">0")Result: 150.
Find the minimum for either category
For OR logic, FILTER keeps either category before MIN calculates the result. East matches even though South is absent.
=MIN(FILTER(B2:B7,(A2:A7="East")+(A2:A7="South")))Result: 250.
Limit the minimum to one month
Use a real date column in D. An inclusive February start and exclusive March start include every February date-time. The matching North row has amount zero, so this result is genuine.
=MINIFS(B2:B7,D2:D7,">="&DATE(2026,2,1),D2:D7,"<"&DATE(2026,3,1))Result: 0.
Other Google Sheets articles you may also like