Calculate the sum of values from a set of records that match specified criteria.
- Database - required
- Field - required
- Criteria - required, range of cells that contains the criteria specified by the user
The function returns the total profit from apple trees, which are in rows 5, 8, and 10 of the data range A4:E10. This function specifies that only the "Profit" column (column 5) is to be included in the calculation.
The function returns the total profit from apple trees with a height between 10 and 16 feet, and all rows 6, 8, and 9 of pear trees. This DSUM function uses the range A1:F3 to select the rows with the specified height and the "Profit" column (column 5) from the data range A4:E10.
The function returns the total cost from apple trees, which are in rows 5, 8, and 10 of the data range A4:E10. This DSUM function specifies that only the "Cost" column (column 4) is to be included in the calculation.
The DSUM function is a useful tool for quickly adding numbers from a list or database that meet specific criteria. It can be used on any worksheet and with multiple accounts.
- The database argument includes field headers.
- The field argument is the name or index of the data field to query.
- The criteria argument is a range of cells that have the same headers as the database.
Frequently Asked Questions
What is the DSUM Function?
The DSUM function is a tool in Sourcetable that allows you to add numbers from a field (column) in a list or database that meet the conditions you specify.
What are the Required Arguments for DSUM?
The three required arguments for the DSUM function are:
What is the Criteria Argument Do In The DSUM Function?
The Criteria argument is the range that contains the conditions specified. This is the range of cells that you want the DSUM function to evaluate when adding the numbers from the field.
How Do I Use the DSUM Function?
Using the DSUM function is relatively straightforward. Simply enter the function into the cell where you want the result to appear, followed by the three required arguments (Database, Field, and Criteria). The syntax for the DSUM function is: DSUM(database, field, criteria).