DSUM Function in Google Sheets

Sum the values in a database that meet specified criteria using the DSUM function.

DSUM Function

The DSUM function in Google Sheets sums the values in a specified field of a database that meet given criteria.

Syntax

DSUM(database, field, criteria)
  • database: The range of cells that make up the database.
  • field: The column number or header name containing the values to sum.
  • criteria: The range of cells that contain the conditions for summing.

Examples

  1. Basic Example

Sum the values in field 2 of the database A1:C10 where criteria are in E1:E2:

=DSUM(A1:C10, 2, E1:E2)
  1. Using Header Names

Sum values in the ‘Total’ column where criteria are in G1:G2:

=DSUM(A1:C10, "Total", G1:G2)

Notes

  • Useful for aggregating values that meet specific conditions.
  • DAVERAGE: Calculate the average of values meeting criteria.
  • DCOUNT: Count cells with numeric values meeting criteria.