PRODUCT function
First
The first parameter.
Other
Additional parameters.
Returns
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:
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
Returns the product of the field values belonging to the Field1:Field10Field1:Field10 range.