Skip to Content

DSUM

Adds the numbers in the field column of records in the database that match the criteria

Syntax

DSUM(database, field, criteria)

Parameters

  • database: Required. The range of cells that makes up the list or database
  • field: Required. Indicates which column is used in the function
  • criteria: Required. The range of cells that contains the conditions you specify

Example

=DSUM(A1:C10, "Profit", A12:A13)
Returns: NumberSince: Excel 2003