WD.COUNTIFS
Description
Returns the number of times that the cells in the specified ranges or arrays meet multiple
conditions (criteria). You can use the * wildcard to match string values. This function is
the same as COUNTIFS but WD.COUNTIFS creates an index (b-tree) for the specified ranges or
arrays, providing better performance for repeated use on the same range/array. Null and
error values are ignored.
Syntax
WD.COUNTIFS(
range
,
criteria
, [
range2
,
criteria2
], ...)
- range: The range/array of values to be evaluated according to the condition.
- criteria: The condition to use to evaluate the values.
- range2: The value, or list of values, to be evaluated according to the condition.
- criteria2: The condition to use to evaluate the values.