DSUM

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.