Adds the numbers in a column of a list or database that match conditions you specify.
구문
DSUM(database, field, criteria)인수
database필수
The range of cells that makes up the list or database.
field필수
Indicates which column is used in the function, either by label or index.
criteria필수
The range of cells that contains the specified conditions.
DSUM is a database function that performs conditional summation based on a criteria range. It is particularly useful when you need to filter data by multiple criteria across different columns before calculating the total.
=DSUM(A1:C10, "Sales", E1:F2)→1500Sums the 'Sales' column for all rows where the 'Region' is 'North' as defined in the criteria range E1:F2.
Prepare your database
Ensure your data is organized in a table with headers in the first row.
Define criteria
Create a separate range that includes the column header and the specific value you want to filter by.
Apply the function
Enter the DSUM formula referencing your database, the target field, and the criteria range.
Yes, you can add more rows or columns to your criteria range to filter by multiple conditions simultaneously.