Functions
MINIFS
Minimum with multiple criteria
When to use it
When should I use MINIFS instead of MIN?
Use MINIFS to find the smallest value among only the cells that meet one or more conditions; use MIN when you want the smallest value across an entire range with no filtering.
What does MINIFS return when no rows match the conditions?
MINIFS returns 0 when no cells satisfy all of the criteria, so check whether an empty match is possible before relying on the result.
Used in
Syntax
MINIFS(min_range,criteria_range1,criteria1,...)