DPRODUCT()
Syntax. DPRODUCT(database,field,criteria)
Definition. This function multiplies the values 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 DPRODUCT() function to multiply the values in a list based on specified criteria.
Example. The wholesaler example used previously does not provide any useful data to demonstrate this function, so we will use a different example.
Note
It was not easy to find an example of this function that makes sense, because database fields are not normally ...
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.
