DPRODUCT
DPRODUCT returns the product of multiplying the values that meet the specified criteria.
=DPRODUCT(database,field,criteria)
The DPRODUCT function returns the product of multiplying the values that meet certain criteria you specify. In the syntax for this function, the database is the cell reference range or named range of the database; the field is referenced as the column number from left to right. The criteria is a range that is referenced and the function operates from the parameters set. The field can also be a cell reference. In Figure 3.5, the product is the multiplication of the cost and the markup. As well, the parameters are Unit 1 with a cost greater than two dollars and a markup less than 30%. The product is 2.88. Of course this is a simple example to illustrate parameters and the operation of the function.
Figure 3.5 The DPRODUCT function multiplies the numbers based on parameters set in the criteria range.