WD.MAXIFS
Description
Returns the maximum value from a range of values, according to one or more criteria. This function is the same as MAXIFS but WD.MAXIFS creates an index (b-tree) for the specified ranges/arrays. This function provides better performance for repeated use on the same ranges/arrays. Null and error values are ignored.
Syntax
WD.MAXIFS(
max_range
, range
, criteria
, [ range2
], [ criteria2
], ...) - max_range: The array of numeric values that you want to return the maximum value from, if the criteria are met.
- range: The range or array of values 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
- 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.