DPRODUCT function is built-in database function in Excel. The DPRODUCT function returns the PRODUCT of the values from the database having multiple conditions. Conditions to the function is given using a table, which must have the same fields or headers as on the database.
Syntax: =DPRODUCT(database, field, criteria)
The DPRODUCT function syntax has the following arguments:
- atabase: A range of cells containing the database. The top row of the database should specify the field names.
- field: The field (column) within the database, that you want to calculate the product of. This can either be a field number, or can be the field name (i.e. the header in the top row of the database) encased in quotes (e.g. “Date”, “Type”, etc).
- criteria: A range of cells that contain the criteria, to specify which records should be included in the calculation. The range can include one or more criteria, which are presented as a field name in one cell and the condition for that field in the cell below.
Example: Let’s look at some Excel DPRODUCT function examples and explore how to use the DPRODUCT function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following DPRODUCT examples would return:
- The Excel DPRODUCT function calculates the product of values in a set of records that match criteria. The values to multiply are extracted from a given field in the database, specified as an argument.
- The database argument is a range of cells that includes field headers, field is the name or index of the field to query, and criteria is a range of cells with headers that match those in database.