Syntax :

= DPRODUCT(database, field, criterion)

Parameters :

• The parameters to are as follows:

Database :

• A set of cells that contains the database. The field names should be specified in the database’s top row.

Field :

• The database field (column) for which you wish to calculate the product. This can be a field number or the field name (i.e. the header in the top row of the database) surrounded by quotations (e.g. “Date”, “Type”, etc).

Criterion :

• A set of cells containing the criteria for determining which records should be included in the computation.
  The range can include one or more criteria, which are displayed in one cell as a field name and the condition for that field in the cell below.

E.g. :