Adds together all the values in a data set created from a condition.
Syntax:
DSUM( range, condition )
Returns the sum of all the values in the range for which the corresponding condition is satisfied.
Formula:
DSUM = i ∑1n xi
where n is the number of selected values and xi is the i‑th value from the selection.
Example:
DSUM(B3:B8, B3:B8<0)
will return the sum of all the negative numbers in cells B3:B8
.
See DAVG for more examples of how to use the condition to control which cells are included.