Dsum Function in Excel

Dsum Function

The Dsum function is used to calculate a specified column in a database that correlates with a specified criteria.

DSUM( database, field, criteria )

Database: A range of cells containing the database. The top of the database needs to specific the field name.

Field: The field within the database that is to be summed.

Criteria: A range of cells that contain the criteria.

Let’s look at the following example.

In this case, we are looking at the database, which is cells A1:D17. We then define the field, which is “Total Sales.” Finally, we have to set our criteria which is illustrated in cells F1:G2.

*When defining the field, you can use both upper and lower case letters. You much ensure the field is surrounded in parenthesis.

Dsum Function

Was this article helpful?

Related Articles

Leave a Reply