Syntax. DSUM(database,field,criteria)

Definition. This function adds the numbers in a column in a list or database that match the specified conditions.


  • database (required) The cell range that makes up the list or database

  • field (optional) Indicates which column is used in the function

  • criteria (required) The cell range containing the field names and the filter criteria

Background. Use the DSUM() function to sum a list of values matching a specific criteria. DSUM() can calculate the sum of data with criteria matching a lot of conditions.

Example. The sales order database contains many orders for your wholesale company. Suppose you want to know the total sales of orders for a particular product in a particular country that are larger than ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.