PRODUCT function

PRODUCT(firstParameter, parameters...) PRODUCT(firstParameter; parameters...)

firstParameter — Number or { Number }

The first parameter.

parameters — Number or { Number } (accepts many)

The remaining parameters.

Returns — Number

The product of the given numbers.

Returns the product of the provided values (multiplied together). PRODUCT(2, 3, 4)PRODUCT(2; 3; 4) returns 24 and is equivalent to 2 * 3 * 42 * 3 * 4.

PRODUCT also accepts arrays, meaning that these formulas are also valid:

PRODUCT({ 2, 3, 4 })PRODUCT({ 2; 3; 4 })
PRODUCT(2, { 3, 4 })PRODUCT(2; { 3; 4 })
PRODUCT({ Field1, Field2, Field3 })PRODUCT({ Field1; Field2; Field3 })
PRODUCT(Field1:Field3)PRODUCT(Field1:Field3)
PRODUCT({ Field1:Field3, Field5, Field6 })PRODUCT({ Field1:Field3; Field5; Field6 })

The Field1:Field3Field1:Field3 range is a short-hand way of expressing an array containing Field1 and Field3, as well as any fields that appear between them, such as Field2. If only Field2 appears between the other two fields, Field1:Field3Field1:Field3 and { Field1, Field2, Field3 }{ Field1; Field2; Field3 } are equivalent.

Use PRODUCTIF or PRODUCTIFS to only consider values satisfying one or several conditions.

Examples

PRODUCT(1, 2, 3)PRODUCT(1; 2; 3)

Returns 6 (1 * 2 * 31 * 2 * 3).

PRODUCT(1, { 2, 3 })PRODUCT(1; { 2; 3 })

Returns 6 (1 * 2 * 31 * 2 * 3).

PRODUCT({ 1, 2, 3 })PRODUCT({ 1; 2; 3 })

Returns 6 (1 * 2 * 31 * 2 * 3).

PRODUCT(Field1:Field10)PRODUCT(Field1:Field10)

Returns the product of the field values belonging to the Field1:Field10Field1:Field10 range.