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:
Database
Criteria:
Syntax: =DPRODUCT(A1:C9,C1,A11:B12)
Result:
Based on the Excel spreadsheet above, the following DPRODUCT examples would return:
Color: Green
Category: Apple
Result: 6985
Color: Red
Category: Xiaomi
Result: 2656
Color: Green
Category: LG
Result: 6523
Color: Red
Result: 1.40658E+14
Category: Apple
Result: 1.22968E+11
Note:
- 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.
