Excel 365 + Google Sheets · MINIFS
The minimum, with conditions
Returns the smallest value among the rows that meet your conditions.
The formula
=MINIFS(C2:C5, A2:A5, "Paper")What each part means
C2:C5Where the prices areA2:A5, "Paper"Only these rows
Example
| A | B | C | |
|---|---|---|---|
| 1 | Product | Supplier | Price |
| 2 | Paper | OfficeCo | 4.20 |
| 3 | Paper | PrintPro | 3.90 |
| 4 | Ink | OfficeCo | 12.00 |
| 5 | Paper | BestDesk | 4.50 |
| 6 | Min paper |
| A | B | C | |
|---|---|---|---|
| 1 | Product | Supplier | Price |
| 2 | Paper | OfficeCo | 4.20 |
| 3 | Paper | PrintPro | 3.90 |
| 4 | Ink | OfficeCo | 12.00 |
| 5 | Paper | BestDesk | 4.50 |
| 6 | Min paper | 3.90 |
Step by step
- Click cell C6.
- Type the formula:
=MINIFS(C2:C5, A2:A5, "Paper") - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Excel 365 and Excel 2021 or newer
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English MINIFS
- Español MIN.SI.CONJUNTO
- Português MÍNIMOSES