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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
