# MINIFS formula generator

> Describe what you need and get a MINIFS formula for Excel and Google Sheets, run on real data before you copy it. Plus 8 tested MINIFS examples.

Source: https://spreadsheetpractice.com/tools/formula-generator/minifs · Updated October 29, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

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.

Describe the task at [MINIFS formula generator](https://spreadsheetpractice.com/tools/formula-generator/minifs) and get a MINIFS formula for Excel and Google Sheets, tested on real data.

## Tested MINIFS examples

### Find the minimum value with criteria in Excel (MINIFS)

`=MINIFS(C2:C8,A2:A8,F1)`

Excel. Result on the sample sheet: $0.39. [See it and try it](https://spreadsheetpractice.com/formulas/minifs-minimum-with-criteria)

### Find the next date after a given date in a list

`=MINIFS(B2:B9,B2:B9,">"&E1)`

Excel. Result on the sample sheet: 7/22/2026. [See it and try it](https://spreadsheetpractice.com/formulas/next-date-in-a-list)

### Find the latest date for each customer

`=MAXIFS($B$2:$B$9,$A$2:$A$9,E2)`

Excel. Result on the sample sheet: 3 rows (F2:F4). [See it and try it](https://spreadsheetpractice.com/formulas/latest-date-for-each-customer)

### Find the earliest date in a list

`=MIN(B2:B9)`

Excel. Result on the sample sheet: 3/8/2026. [See it and try it](https://spreadsheetpractice.com/formulas/find-the-earliest-date-in-a-list)

### Find the next upcoming date in a list

`=MINIFS(B2:B7,B2:B7,">="&E1)`

Excel. Result on the sample sheet: 10/30/2026. [See it and try it](https://spreadsheetpractice.com/formulas/next-upcoming-date-in-a-list)

### Find the minimum value excluding zeros

`=MINIFS(B2:B7,B2:B7,">0")`

Excel. Result on the sample sheet: $22.50. [See it and try it](https://spreadsheetpractice.com/formulas/minimum-excluding-zeros)

### Find the next highest value in a list

`=XLOOKUP(E1,B2:B7,A2:A7,"Too big",1)`

Excel. Result on the sample sheet: Large. [See it and try it](https://spreadsheetpractice.com/formulas/find-next-highest-value)

### Find the first clock-in time for each day

`=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). [See it and try it](https://spreadsheetpractice.com/formulas/first-clock-in-of-each-day)

## Questions

### What does the MINIFS formula generator do?

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.

### What does MINIFS do?

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.

### Can I learn to write MINIFS formulas myself?

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.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
