Find the minimum value with criteria in Excel (MINIFS)
=MINIFS(C2:C8,A2:A8,F1)Excel · result on the sample sheet: $0.39
Describe what you need and get a working MINIFS formula for Excel and Google Sheets, tested on real data before you copy it. MINIFS returns the smallest value among the rows that meet one or more conditions: the cheapest quote for a part, the earliest due date in a project, the lowest score above zero.
Each formula below was calculated on its own sample sheet. Open one to see the sheet, why it works, and to try it yourself.
=MINIFS(C2:C8,A2:A8,F1)Excel · result on the sample sheet: $0.39
=MINIFS(B2:B9,B2:B9,">"&E1)Excel · result on the sample sheet: 7/22/2026
=MAXIFS($B$2:$B$9,$A$2:$A$9,E2)Excel · result on the sample sheet: 3 rows (F2:F4)
=MIN(B2:B9)Excel · result on the sample sheet: 3/8/2026
=MINIFS(B2:B7,B2:B7,">="&E1)Excel · result on the sample sheet: 10/30/2026
=MINIFS(B2:B7,B2:B7,">0")Excel · result on the sample sheet: $22.50
=XLOOKUP(E1,B2:B7,A2:A7,"Too big",1)Excel · result on the sample sheet: Large
=MINIFS($A$2:$A$10,$A$2:$A$10,">="&C2,$A$2:$A$10,"<"&C2+1)Excel · result on the sample sheet: 3 rows (D2:D4)
You describe the task in plain English, and it writes the formula, using MINIFS where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.
MINIFS returns the smallest value among the rows that meet one or more conditions: the cheapest quote for a part, the earliest due date in a project, the lowest score above zero.
Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the MINIFS function page has a practice exercise.