O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

DSUM()

Syntax. DSUM(database,field,criteria)

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

Arguments

  • 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required