DSUM

DSUM treats a range with a header row as a database and sums values in a specified field for all records matching the criteria range. It is more flexible than SUMIF for multi-column conditions and is well suited for named-range-driven reporting.

Excel

=DSUM(A1:C5,"Revenue",E1:E2)

Google Sheets

=DSUM(A1:C5,"Revenue",E1:E2)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1Set up your data with a header row, then create a criteria range elsewhere with matching headers and condition values.
2Enter =DSUM(database, field, criteria) where field is the column name in quotes or its index number.
3Update the criteria range to change what is summed without modifying the formula.

Need a version for your data?

Try: “Sum revenue only for records where the region is East.”

DAVERAGE DCOUNT DCOUNTA

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

DSUM

Try it with your data

How it works

Related