DPRODUCT

Excel Functions

Get product from matching records

Syntax

EXCEL

=DPRODUCT(database, field, criteria)

Arguments

Parameter	Description
`database`	Database range including headers.
`field`	Field name or index to count.
`criteria`	Criteria range including headers.

Return Value

The calculated product

Details

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. Field can be specified with a name or index. Using the example above, you can get the product of "Echo" dimensions with either formula below: The criteria can include a variety of expressions, including some wildcards. The table below shows some examples: Note: support for wildcards is not as extensive as with other functions like COUNTIFS, SUMIFS, MATCH, etc. For example, the pattern ??? will match

Examples

Example 1

Field can be specified with a name or index. Using the example above, you can get the product of "Echo" dimensions with either formula below: