Multiplies all the numbers given as arguments and returns the product.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
PRODUCT(number1, [number2], …)The PRODUCT function is used to multiply a series of numbers, cell references, or ranges. It is particularly useful for calculating the product of large datasets where manual multiplication would be inefficient.
=PRODUCT(5, 10)Ergebnis: 50
Multiplies 5 by 10.
=PRODUCT(A1:A3)Ergebnis: 6
Multiplies the values in cells A1, A2, and A3 (assuming they contain 1, 2, and 3).
The PRODUCT function ignores cells that contain text or empty values.