DPRODUCT

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.