DSUM function in Excel

What is DSUM function in Excel?

The DSUM function is one of the Database functions of Excel.

It adds the numbers in the field (column) of records in the database that match the conditions you specify.

We can find this function in the Database of insert function Tab

How to use DSUM function in excel

1. Click on empty cell (like F5 )

2. Click on the fx icon (or press shift+F3)

3. In the insert function tab you will see all functions

4. Select Database category

5. Select the DSUM function

6. Then select ok

7. In the function arguments Tab you will see DSUM function

8. In the Database section you can enter the range of cells that makes up the list or database. A database is a list of related data (ex: Table1)

9. Field section is either the label of the column in double quotation marks or a number that represents the column’s position in the list (ex: C1)

10. Criteria section is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition (ex: Table1)

11. You will see the result in formula result section

Examples of DSUM function in excel

Example1:

calculate sum of student age with DSUM function

Example 2:

calculate sum of student height with DSUM function

Python code for DSUM function

import pandas as pd

df=pd.read_csv(‘example.csv’)

sumdf = df.sum(axis=0, numeric_only= True)

print (sumdf)

DSUM related functions :

DCOUNT Function
DCOUNTA Function
DMIN Function
DMAX Function
DPRODUCT Function

DAVERAGE function

Related posts:

Excel DCOUNTA function Excel QUOTIENT Function Excel DCOUNT Function How to select every other cell in a row in Excel