Dsum Function Excel

Dsum Function in Excel 2007
Database functions in Excel like Dsum are powerful analytical and calculation tools.
The function takes 3 arguments or parameters and then adds the numbers in the field (column) of records in the database that match the specified criteria or condition.
The 3 parameters are:

Database is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
Field indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as “Designation” or “Salary” or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column (Designation in our example), 2 for the second column (Salary in our example), and so on.
Criteria is the range of cells that contains the conditions that you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column. In our example the criteria range is A9 to C10.

Implementing Database functions:

  1. Select the labels of the columns, copy and paste them 3-4 rows below your data or 3-4 columns away from your data.
  2. Now specify your criteria like ‘Manager’ under the designation label and or some salary value under the salary label as shown in our example.
  3. Next click inside a cell where you wish to get your reults. Type the ‘=dsum(…….)’ formula by providing the arguments as shown in the video. The first argument is your database. Select the data range including the labels. You can also assign a ‘name’ to the range like ‘mydata’ and use it.
  4. Then define the ‘field’ using the column label like ‘Salary’ or a column number. The left-most column is designated as 1, then 2 2, and so on
  5. The final step is to define the criteria range which includes the headers that you copied and pasted and the criteria values.
  6. After closing the bracket press enter and the result will be displayed.

Further reading:
Excel Database Functions: DAVERAGE and DSUM

3 thoughts on “Dsum Function Excel

  1. A great blog. This is great info I was not aware of. Now I know why a lot of my blogs are on page 1 of Google. I thought I must be doing soeihtmng right. All the best.

  2. Lovely! I love passato di peperoni, usually it is a bit of a 'posh' starter in Italy, in a way one of those things that people serve before many other dishes, but never for me, just a big bowl and some nice crusty bread is all I need in a stormy night 🙂

  3. Hello, i feel that i noticed you visited my website thus i got here to “go back the favor”.I’m attempting to find things to enhance my web site!I suppose its good enough to use some of your ideas!!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.