DPRODUCT
Multiplies the values in a particular field of records that match the criteria in a database
Syntax
DPRODUCT(database, field, criteria)
Parameters
- database: Required. The range of cells that makes up the list or database
- field: Required. Indicates which column is used in the function
- criteria: Required. The range of cells that contains the conditions you specify
Example
=DPRODUCT(A1:C10, "Yield", A12:A13)