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

What is a Macro?

Macro is just the name given to the codes written in VBA. So our codes, henceforth, will be referred to

Read More »

If Function

The IF Function in excel is a logical test that can be run using specific conditions. This logical test returns

Read More »

XLOOKUP Function in Excel

XLOOKUP replaces VLOOKUP AND HLOOKUP permanently! Speed up your spreadsheet by changing your default lookup function. Add a 4th and 5th argument!

Read More »
Scroll to Top