DPRODUCT

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 1n 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 Fireworkz 2.00.