DSUM Function: How to Sum with Complex Conditions in Excel

This guide provides a clear, practical overview of "DSUM Function: How to Sum with Complex Conditions in Excel". It organizes the most useful details, explains important considerations, and highlights the steps or choices that matter most.

• How to use the SUM function to calculate the sum in Excel
• Instructions for creating interactive charts in Excel with the INDEX function
• How to use Vlookup function in Excel

Formula of DSUM function in Excel

The DSUM function is a function that adds numbers in a field or column in a data list that satisfy specified conditions. The function syntax is =DSUM(database; field; criteria) .

In there:

• Database : is the database range containing the column to be summed and the column to be checked for the condition. The list contains the first row as the column header.
• Field: is a required argument that specifies the name of the column used to sum the data. You can enter the column title in double quotes, or use a number representing the column position in the list without double quotes, or refer to the column title you want to sum.
• Criteria: is a required argument, the range of cells containing the condition you want the DSUM function to check.

User Note:

• Any range can be used for criteria if the range contains at least 1 column label and at least 1 cell below the column heading that will define the conditions for that column.
• Do not place the condition range at the bottom of the list because there will be no place to add more information to the list.

Example of using the DSUM function to calculate conditional sum

We will process the data table as shown below.

Example 1. Calculate the total amount sold of iPhone products

Step 1:

First we create a condition range for the DSUM function to calculate the total amount sold of iPhone products. The condition for the DSUM function is iPhone*.

Note: Use * to represent other characters.

Step 2:

Next, the user enters the DSUM function formula as =DSUM(A6:E13;"Total Amount";C2:C3) .

In there:

• A6:E13 is the database range containing the column to sum and the column containing the condition to check.
• 'Total' is the column heading that will use the value in that column to calculate the total.
• C2:C3 is the condition range containing column headers and 1 condition value.

Press Enter and we will get the exact result as shown.

Or the user can replace the value in Field with a reference to the Total column. The input formula is =DSUM(A6:E13;E6;C2:C3) . The result is the same as when you enter the Total column into the formula.

Example 2. Calculate the total amount of products sold with quantity greater than or equal to 5.

Step 1:

First user will also need to create condition range with column header Sales Quantity and condition value is >=5 as shown below.

Step 2:

We enter the function formula =DSUM(A6:E13;E6;C2:C3) and press Enter.

The total amount will be as shown in the picture.

In general, using the DSUM function in Excel is very simple. You can use the function to calculate the sum of values in columns with simple conditions. With more complex conditions, we can use the SUMIF function.

See also:

• Instructions for using the Index function in Excel
• 3 ways to calculate sum in Excel
• How to print Excel spreadsheet in one page

Good luck!