DPRODUCT
Syntax:
DPRODUCT ( database , field , criteria )
Description: Computes the product of the values of the cells in a column of a list or database that match the specified criteria. (See the DAVERAGE function §3.17.7.77.)
Arguments:
Name |
Type |
Description |
|---|---|---|
database |
reference |
The range of cells that makes up the list or database. |
field |
text, number |
The column to which criteria shall be applied. |
criteria |
reference |
The range of cells that contains the specified conditions. |
For a detailed description of each argument, see the DAVERAGE function §3.17.7.77.
Return Type and Value: number – The product of the values of the cells that correspond to the specified criteria.
example: