Skip to content

DSUM

DatabaseExcel 2007

Sum a field of the records that match a criteria range.

Syntax

DSUM(database, field, criteria)

Arguments

database
The table including its header row.
field
The column to sum — a header name in quotes, or its number.
criteria
A small range with matching headers and condition rows (supports >, <, wildcards, formulas).

Examples

=DSUM(A1:F500, "Amount", H1:I2)

→

Good to know

  • SUMIFS is usually simpler now; the D-functions shine with complex OR criteria laid out as rows.

Related functions

DGETDCOUNTSUMIFS

More Database functions

DAVERAGEDCOUNTDCOUNTADGETDMAXDMINDPRODUCTDSTDEVDSTDEVPDVARDVARP

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.