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) | 43 | Evaluates the sum of all ages in "Berlin". |