How to use DSUM function in Excel

In Excel basic functions, the DSUM function is one of the common functions. This function will calculate the sum of a field, or 1 column to satisfy the condition you specified in the data table. The formula that uses the DSUM function as well as the method's conditional calculation is relatively simple and faster than the SUMIF function in Excel. The following article will guide you how to use the DSUM function in Excel to calculate the total column with the given conditions.

1. How to use the SUM function to calculate totals in Excel
2. Instructions for creating interactive charts in Excel with INDEX function
3. How to use Vlookup function in Excel

Instructions for conditional calculation using DSUM

The DSUM function is the function of adding numbers in a field, the column in the data list satisfies the specified conditions. The function syntax is DSUM = DSUM (database; field; criteria) .

Inside:

1. Database is a required argument, a database created from a cell range. This data list will contain data as fields, including fields to check conditions and fields to calculate totals. The first row list is the column header.
2. Field is a required argument specifying the column name used to summarize the data. You can enter the column header name in quotation marks, or use a number that represents the column position in the list without quotes, or refer to the column heading you want to sum.
3. Criteria is a required argument, the cell range contains the condition that you want the DSUM function to check.

User note

1. It is possible to use any range for a criteria if that range contains at least 1 column label and at least 1 cell below the column header that determines the condition for that column.
2. Do not set the condition range at the bottom of the list because there will be no additional information on the list.

We will process the data table as shown below.

1. Calculate the total amount sold of iPhone products

Step 1:

First of all, we create a range of conditions for the DSUM function to calculate the total amount of money sold by iPhone products. Condition for DSUM function is iPhone *.

Step 2:

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

Inside:

1. A6: E13 is the scope of the database containing the column to be summed and the column contains the condition to be checked.
2. 'Money' is the column header that will use the value in that column to calculate the sum.
3. C2: C3 is the condition range containing column headings and a condition value.

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

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

2. Calculate the total amount of products sold in quantities greater than or equal to 5.

Step 1:

First, the user will also need to create a range of conditions with the Sales quantity column header and the condition value is > = 5 as shown below.

Step 2:

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

The total amount will be as shown in the picture.

In general, the use of DSUM functions in Excel is extremely simple. You can use functions to sum values ​​by column with simple conditions. With more complex conditions we can use the SUMIF function.

See more:

1. Instructions for using Index function in Excel
2. 3 ways to calculate totals in Excel
3. How to print an Excel spreadsheet in a page

I wish you all success!