Buzz
Whether you're a novice or an experienced Excel user, knowing about the Dsum function is essential. It's a fast summation function with a simple formula, easy to apply. Similar to other summation functions, Dsum computes totals based on a specified condition within a row or column of a database. Join Mytour on an in-depth exploration of how to use the Dsum function in Excel.
Dsum Function and Examples
1. How to Use DSUM Function in Excel
Let's delve into the syntax and meanings of values in this function.
- Function syntax: DSUM(database, field, criteria)
- DSUM Function Meaning: Adds numbers in a field or column of a list or database based on the specified conditions.
- Where:
+ Database: This is a mandatory value, representing the data range for the function to identify values for condition matching and summing. The data range is a list containing related data, where rows are records and columns are fields. The first row of the list is headers for each column.
+ Field: Mandatory value. It is the column that will be used for summing in the data range of the DSUM function. You need to enter the correct header (label) of the column in double quotes, such as 'Quantity,' 'Profit,'.... Or you can use a number (not in double quotes) to indicate the position of the column in the data range: 1 corresponds to the first column, 2 for the second column, and so on.
+ Criteria: Mandatory value. It is the condition range that you want to set for the function to calculate. You will need to set conditions in the criteria range that include at least one cell below the column label.
2. Some Notes on Using DSUM Function:
- When using the conditional summing function DSUM, you need to set conditions in the criteria range that include at least one cell below the column label, where you specify the condition for that column.
Example: If the range C12:D13 contains the column label 'Brand' in cell J4, and there is the brand Asus in cell J5, you have defined the Criteria value for calculation.
- Although the criteria range can be positioned anywhere on the worksheet, it is advisable not to place it below the list. If you need to add information to the data range, the new information will be added to the first row below the data range. If the row below the data range is not empty, Excel cannot add new information to it.
- Ensure that the criteria range does not overlap with the data range.
- You can also enter the Field value as the header (label) you want to sum.
3. Illustrative Example of Using DSUM Function:
In the example below, Mytour will calculate the total sales amount of Asus laptops.
Step 1: Enter the formula Dsum: =DSUM(B4:G9,G4,J4:J5) into cell G10.
Step 2: Press Enter, and the result will appear as VND 83,332,000.00, which is the accurate outcome.
Here is a detailed guide on how to use DSUM - the conditional sum function in Excel. Additionally, there are detailed examples to help you better understand. We hope that through this article, you can comprehend and easily apply the Dsum function to your practical work.
Do you use the DSUM function in your practical work? Any challenges or tips in the usage process? Share your experiences and questions about this conditional sum function in the comments below to collaborate and find solutions together.
