PRODUCT (First, Other...) PRODUCT (First; Other...)
First
The first number or array of numbers.
Other
Additional numbers or arrays of numbers.
Returns
Number 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 })
Use PRODUCTIF or PRODUCTIFS to only consider values satisfying one or several conditions.