Syntax:
DPRODUCT(range, condition)
Returns the product of all those values in the range for which the condition is satisfied.
Example:
DPRODUCT(B3:B8, B3:B8>0)
will return the product of all the positive numbers in cells B3
to B8
.
See DAVG
for more examples of how to use the condition to control which cells are included.
Added in 2.00.