WD.MAXIF
Description
Returns the maximum value from a range or array of values, according to a criterion. This function creates an index (b-tree) for the specified range or array, providing better performance for repeated use on the same range/array. Null and error values are ignored.
Syntax
WD.MAXIF(
range
, criteria
, max_range
) - range: The values, or the range/array of cells, to be evaluated according to the condition.
- criteria: The condition to use to evaluate the values.
- max_range: The array of numeric values that you want to return the maximum value from, if the criteria are met.
Notes
- The 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".
- The function isn't case-sensitive. Example: When evaluating the values in range against the criteria, the text strings "MONTH" and "month" are considered a match.
- Whenever you use a text string or an expression as a condition, surround it with quotes.
- In text-based criteria, you can use the ? wildcard to match any single character or the * wildcard to match any sequence of characters.