Skip to main content
Version: Streamsheets 2.4

DSUM

Returns the sum of all values in a column of the cell range which matches the specified criteria.

Syntax

=DSUM(DataRange, ColumnIndex, CriteriaRange)

Arguments

NameDescription
DataRangeCell range, that containes the data to evaluate. The range must include the field labels.
ColumnIndexColumn label or index to calculate the sum for.
CriteriaRangeSpecifies the conditions a row in cell range must fulfill. Must define at least one column with a label and a cell below which specifies the condition.

Return Value

The sum of all values of the matching column.

Example

FunctionResultComment
=DSUM(A5:C9,2,A2:C3)
43Evaluates the sum of all ages in "Berlin".