All functions / Statistics
MINIFS
The smallest value among cells that meet conditions.
Syntax
=MINIFS(min_range, criteria_range, criteria, [criteria_range1, [criteria_range2], …])
Arguments
min_range: The cells to look at.criteria_range: A range to test.criteria: The condition.criteria_range(optional): More range/condition pairs.