MINIFS(min_range, criteria_range1, criteria1 [,criteria_range2, criteria2] [..]) 
Returns the smallest value in a list or array of numbers that satisfies multiple conditions. 
min_range  The actual cells to min. 
criteria_range1  The range of cells you want evaluated. 
criteria1  The expression that contains the criteria. 
criteria_range2  (Optional) The range of cells you want evaluated. 
criteria2  (Optional) The expression that contains the criteria. 
Remarks 
* Added in Excel 2019. * This function includes hidden rows. * This function supports wildcards (? and *). * Wildcard character: ? = a single character. * Wildcard character: * = multiple characters. * This function uses the actual cell values and not the displayed formatted values. * You can have up to 127 criteria. * If "min_range" and "criteria_range" are not the same size and shape, then #VALUE! Is returned. * If the function is not available, then #NAME? is returned. * You can use the MIN function to return the smallest value with no conditions. * You can use the MINA function to include logical values and text. * You can use the MINIFSVISIBLE  User Defined Function if you only want to exclude hidden rows. * This is similar to the AVERAGEIFS function. * This is similar to the COUNTIFS function. * This is similar to the MAXIFS function. * This is similar to the SUMIFS function. * For the Microsoft documentation refer to support.office.com 

1  What is the smallest value in the range "C1:C5" that have "Barry" in the range "B1:B5". 2  What is the smallest value in the range "C1:C5" that have "Barry" in the range "B1:B5". Notice that prefixing the condition with an equal sign means the same thing. 3  What is the smallest value in the range "C1:C5" that have "Simon" in the range "B1:B5". 4  What is the smallest value in the range "C1:C5" that have "Barry" in the range "B1:B5" and have a value not equal to 20 in the range "C1:C5". 5  What is the smallest value in the range "C1:C5" that have "Barry" in the range "B1:B5" and have a value equal to 20 in the range "C1:C5". 6  What is the smallest value in the range "C1:C5" that have "Barry" in the range "B1:B5" and have a value greater than the value in the cell "C3" in the range "C1:C5". 
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top