DSUM Function Explained
The DSUM Function in Microsoft Excel is used to calculate the sum of values in a column or database that meet a specified criteria. It takes three arguments: database, field, and criteria. The database argument is a range of cells that make up the list or database. The field argument is the column in the database that contains the values to be summed. The criteria argument is a range of cells that contain the criteria used to filter the database.
DSUM Function Syntax
DSUM(database, field, criteria)
- database: The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields.
- field: The column in the list or database that is used in the calculation.
- criteria: The range of cells that contains the criteria used to filter records.