MINIFS
Returns the minimum value among cells specified by a given set of conditions or criteria.
StatisticalModern Excel FunctionsStatistics & Analysis
What it does
Returns the smallest number in a range that meets multiple criteria.
Syntax
MINIFS(min_range, criteria_range1, criteria1, ...)
Arguments
min_range(range) — Range to check for min.criteria_range1(range) — Range to evaluate.criteria1(criteria) — Condition.
Examples
Min If
Min score for 'B'.
FORMULA
=MINIFS(B2:B5, A2:A5, "B")
RESULT
70
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Group | Score |
| 2 | A | 80 |
| 3 | B | 70 |
| 4 | A | 95 |
| 5 | B | 88 |