DSUM
Adds the numbers in the field column of records in the database that match the criteria.
DatabaseDatabase & Lists
What it does
Sums numbers in a database column that match criteria.
Syntax
DSUM(database, field, criteria)
Arguments
database(range) — Database range.field(text) — Column to sum.criteria(range) — Criteria range.
Examples
Database Sum
Sum Sales where Region='East'.
FORMULA
=DSUM(A1:B5, "Sales", D1:D2)
RESULT
300
SAMPLE DATA
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Region | Sales | Region | |
| 2 | East | 100 | ||
| 3 | West | 200 | ||
| 4 | East | 200 | ||
| 5 | North | 50 | ||
| 6 | East |