MINIFS

MINIFS(min_range, criteria_range1, criteria1 [,criteria_range2, criteria2] [..])

Returns the smallest numerical value 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

* This function was added in Excel 2019 to allow for multiple conditions.
* There is no MINIF function.
* This function includes hidden cells.
* This function is not case sensitive when matching text strings.
* This function supports wildcards (? and *).
* Wildcard character: ? = a single character.
* Wildcard character: * = multiple characters.
* To include the actual wildcard characters use a tilde prefix (~?), (~*) and (~~).
* This function uses the actual cell values and not the displayed formatted values.
* You can have a maximum of 126 (criteria_ranges and 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 numerical value.
* You can use the MINA function to return the smallest numerical value (including logical values and text).
* You can use the MINVISIBLEIFS - User Defined Function to exclude hidden cells.
* You can use the DMIN function to return the smallest value in a column that satisfies multiple conditions.
* You can use the IFS function to return the value based on multiple conditions.
* This is similar to the AVERAGEIFS, COUNTIFS, MAXIFS and SUMIFS functions.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B	C
1	=MINIFS(C1:C5, B1:B5, "Jan") = 20	Jan	30
2	=MINIFS(C1:C5, B1:B5, "=Jan") = 20	Feb	40
3	=MINIFS(C1:C5, B1:B5, "=Feb") = 40	Jan	20
4	=MINIFS(C1:C5, B1:B5, "Jan", C1:C5, "<>20") = 30	Feb	60
5	=MINIFS(C1:C5, B1:B5, "Jan", C1:C5, "=20") = 20	Mar	80
6	=MINIFS(C1:C5, B1:B5, "Jan", C1:C5, ">" & C3) = 30

1 - What is the smallest value in the range "C1:C5" that have "Jan" in the range "B1:B5".
2 - What is the smallest value in the range "C1:C5" that have "Jan" 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 "Feb" in the range "B1:B5".
4 - What is the smallest value in the range "C1:C5" that have "Jan" 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 "Jan" 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 "Jan" in the range "B1:B5" and have a value greater than the value in the cell "C3" in the range "C1:C5".