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

Name

Description

DataRange

Cell range, that containes the data to evaluate. The range must include the field labels.

ColumnIndex

Column label or index to calculate the sum for.

CriteriaRange

Specifies 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

Function

Result

Comment

=DSUM(A5:C9,2,A2:C3)

DSUM

43

Evaluates the sum of all ages in “Berlin”.