Lowest group A score
| A | B | C | |
|---|---|---|---|
| 1 | Name | Group | Score |
| 2 | Ana | A | 72 |
| 3 | Ben | B | 88 |
| 4 | Cara | A | 91 |
| 5 | Dan | B | 65 |
| 6 | Eli | A | 84 |
Formula: E2: =MINIFS(C2:C6,B2:B6,"A")
Result: 72
Among 72, 91, and 84, the minimum is 72.
Google Sheets function
MINIFS in Google Sheets
MINIFS with worked examples you can test in the live grid. The argument details are in the Excel guide.
In Google Sheets
The arguments and common errors are covered in the MINIFS Excel guide; check the function help in Google Sheets for its own argument list.
Worked examples in Google Sheets
Lowest passing score
| A | B | C | |
|---|---|---|---|
| 1 | Name | Group | Score |
| 2 | Ana | A | 72 |
| 3 | Ben | B | 88 |
| 4 | Cara | A | 91 |
| 5 | Dan | B | 65 |
| 6 | Eli | A | 84 |
Formula: E2: =MINIFS(C2:C6,C2:C6,">=70")
Result: 72
The score 65 is excluded by the threshold.
Lowest group B score
| A | B | C | |
|---|---|---|---|
| 1 | Name | Group | Score |
| 2 | Ana | A | 72 |
| 3 | Ben | B | 88 |
| 4 | Cara | A | 91 |
| 5 | Dan | B | 65 |
| 6 | Eli | A | 84 |
Formula: E2: =MINIFS(C2:C6,B2:B6,"B")
Result: 65
Group B contains 88 and 65.
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in F2: =MINIFS(C2:C7,A2:A7,"West")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Region | Product | Units | Price | Result | |
| 2 | East | Pen | 120 | 2.5 | 30 | |
| 3 | West | Pen | 80 | 2.5 | ||
| 4 | East | Book | 45 | 12 | ||
| 5 | North | Book | 60 | 12 | ||
| 6 | West | Lamp | 30 | 25 | ||
| 7 | East | Lamp | 15 | 25 |
Result in F2: 30
Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.