Arte SheetsLearn. Try. Understand.

Math

DSUM function: sum database columns using multi-row AND/OR criteria ranges

Total a named column in a structured table using DSUM when filter rules combine AND columns across OR criteria rows.

Open spreadsheet ↗

Criteria-table filtering with DSUM

DSUM(database, field, criteria) sums a target column in a table with headers using an external criteria range. Cells in the same criteria row combine with AND logic, while multiple criteria rows combine with OR logic.

Pass the column header name in quotes (such as "Amount") or its 1-based column position.

=DSUM(A1:C5, "Amount", E1:F2)

Try the example

Use the original values or change them to test your understanding.