WD.SUMIFS
Description
Adds the numbers specified in the sum_range, if a set of criteria are met. This function is
the same as SUMIFS but WD.SUMIFS creates an index (b-tree) for the specified range or array.
This function provides better performance for repeated use on the same range/array. Null and
error values are ignored.
Syntax
WD.SUMIFS(
sum_range
,
range
,
criteria
, [
range2
,
criteria2
], ...)
- sum_range: The range of values, or values in cells, to sum if all criteria are met.
- range: The range or array of values to test.
- criteria: The condition to test each value against.
- range2: The range of values, or cells, to test.
- criteria2: The condition to test each value against.