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

Leave a Reply

SECOND Function

The SECOND function in Excel returns the second component of a specified time as a number between 0-59. Syntax: =SECOND(serial_number)

Read More »

HLOOKUP Function in Excel

HLOOKUP Function Glossary What is HLOOKUP? HLOOKUP Example Exact Match vs Approximate Match (False vs True) HLOOKUP from another Workbook

Read More »
Scroll to Top