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=n 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.