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 | Type | Description |
|---|---|---|
| DataRange | Range | Cell range, that contains the data to evaluate. The range must include the field labels. |
| ColumnIndex | Number | Column label or index to calculate the sum for. |
| CriteriaRange | Range | 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
| Type | Description |
|---|---|
| Number | The sum of all values of the matching column. |
Examples
| A | B | C | |
|---|---|---|---|
| 1 | Name | Age | City |
| 2 | Berlin | ||
| 3 | |||
| 4 | Name | Age | City |
| 5 | Miller | 24 | Berlin |
| 6 | Mayer | 30 | Oslo |
| 7 | Smith | 26 | Munich |
| 8 | Jones | 19 | Berlin |
| Formula | Result | Comment |
|---|---|---|
| 43 | Evaluates the sum of all ages in "Berlin". |