WD.SUMIF
Description
Adds the numbers specified as arguments, if a condition is met. This function is the same
as SUMIF but WD.SUMIF 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.SUMIF(
range
,
criteria
, [
sum_range
])
- range: The range/array of values to test.
- criteria: The condition to test each value against.
- sum_range: The range of values, or cells, to add together. If not specified, the values in the range argument are summed.