Summing Records With DSUM
Total a field for rows that match your criteria range.
What DSUM Does
DSUM adds up the numbers in one column of a table, but only for the rows that match a criteria range. Think of it as a SUMIFS that reads its conditions from a block of cells instead of from inside the formula.
It shines when you have many conditions or want users to change the filters by editing cells rather than rewriting formulas.
The DSUM Syntax
The pattern is:
DSUM(database, field, criteria)
- database - the full table including headers, e.g.
A1:C13. - field - the column to total, given as a header name in quotes like
"Amount"or as a column number. - criteria - the criteria range you built earlier.
=DSUM(A1:C13, "Amount", E1:E2)