How to use the Excel DPRODUCT function

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

Excel DPRODUCT function 1 - How to use the Excel DPRODUCT function

Criteria:

Excel function - How to use the Excel DPRODUCT function

Syntax:  =DPRODUCT(A1:C9,C1,A11:B12)

Result:

Excel function 2 - How to use the Excel DPRODUCT function

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.
READ:  How to use the Excel FLOOR function

Add a Comment

Your email address will not be published. Required fields are marked *