EXCEL DSUM FUNCTION

The Excel Dsum function computes the sum of a database field (column) for chosen records that meet user-specified conditions. The function is quite similar to the Excel Sumifs function, which was introduced in Excel 2007 for the first time.

Syntax :

=DSUM ( database, field, criteria )

Parameters :

  • The following are the arguments:

Database :

  • A set of cells that contains the database. The field names should be specified in the database’s top row.

Field :

  • The database field (column) that is to be summed.
  • This can be a field number or the field name (i.e. the header in the top row of the database) surrounded by quotations (e.g. “Area”, “Quarter”, etc).

Criterion :

  • A set of cells containing the criteria for determining which records should be included in the computation. The range can include one or more criteria, which are given in one cell as a field name and the condition for that field in the cell below.

E.g. :

QuarterArea
>2South

Step By Step Guide of DSUM Function

Example :

The Dsum function is used in the example below to determine total sales in quarters 3 and 4, in the “North” area. Cells F1 – G2 specify the conditions, while cell F3 displays the Dsum formula. The Dsum function above computes the sum of the values in cells D10, D11, D14, and D15, and hence returns the number $1,210,000.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now