FUNCTION CATALOGUE / STATISTICAL
MINIFS Excel function
Returns the smallest value meeting conditions.
Correct sentence to use
Find the smallest value in [min range] where [condition] is met.
Modify this query in PlainFormula →Example formula
=MINIFS(D:D,B:B,"London")
Returns the minimum value satisfying criteria.
Syntax
MINIFS(min_range, criteria_range1, criteria1, …)
Argument signature: min_range, criteria_range1, criteria1, …
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.