MINIFS
Description
Returns the minimum value from a range of values, according to one or more
criteria.
Syntax
MINIFS(
min_range
,
range
,
criteria
, [
range2
], [
criteria2
], ...)
- min_range: The array of numeric values that you want to return the minimum value from, if the criteria are met.
- range: The values, or the range of cells, to be evaluated according to the condition.
- criteria: The condition to use to evaluate the values.
- range2: The second set of values, or the range of cells, to be evaluated according to the condition.
- criteria2: A second condition to use to evaluate the values.
Notes
- Each condition can be one of these:
- A numeric value (integer, decimal, date, time, or logical value), such as 5, 12/5/2019, or TRUE.
- A text string, such as "Name" or "November".
- An expression, such as ">9" or "<>0".
- In text-based criteria, you can use the ? wildcard to match any single character or the * wildcard to match any sequence of characters.
- Whenever you use a text string or an expression as a condition, surround it with quotes.
- The function isn't case-sensitive. Example: When evaluating the values in criteria_range against the criteria, the text strings "MONTH" and "month" is considered a match.