Multiplies together all the values in a data set created from a condition.
Syntax:
DPRODUCT(range, condition)
Returns the product of all the values in the range for which the corresponding condition is satisfied.
Formula:
DPRODUCT = ∏i=n xi
where n is the number of selected values and xi is the i-th value from the selection.
Example:
DPRODUCT(B3:B8, B3:B8>0)
will return the product of all the positive numbers in cells B3:B8
.
See DAVG
for more examples of how to use the condition to control which cells are included.
Revisions:
This function was added in 2.00.