DPRODUCT Function Explained
The DPRODUCT function in Microsoft Excel multiplies values in a column or database that match specified criteria. It takes three arguments: the database range, the field to multiply, and the criteria range. The function returns the result of the multiplication.
DPRODUCT Function Syntax
DPRODUCT(database, field1, criteria1, [field2, criteria2], ...)
- database: The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields.
- field1: The column in the list or database that is used in the criteria.
- criteria1: The pattern or test to apply to field1.
- field2, criteria2: (Optional) Additional columns and criteria to use to further narrow the scope of the product.