Description Uses specified criteria to select records from a database, then adds the numeric values in a specified field of the selected records.
Note This is a database function, which has specific requirements that are different from most functions. For information and expanded argument descriptions, see "Database Functions".
Syntax DSUM ( database, field, criteria)
| Argument | Description |
|---|---|
| database | A reference to a range containing data that the function searches. |
| field | The column within database that contains the data you want to add. |
| criteria | A reference to a range containing search criteria. |
Remarks If there are no numeric values in field in the selected records, DSUM will display 0.
Examples This example uses the example database and criteria ranges shown in "Database Functions". This function returns 73490:
DSUM(A1:D8,"Commissions 96",B10:B11)
See Also DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DVAR, DVARP
