The function MINIFs finds the smallest value from a range of cells that meet an specific criteria from a separate range.
Syntax:
=MinIfs(min range, criteria range 1, criteria 1, …)
Min range. Is the group of values or reference to a range of cell containing the values you want to find the smallest value.
Criteria range 1. is the reference to a range of cell to be use to evaluate with the criteria.
Criteria 1. Is the criteria that defines which cells will be evaluated to find the largest value.
this function allows to add up to 126 criteria range/criteria pairs.