PRODUCT Function in Google Sheets: Examples, Pitfalls & Compatibility
PRODUCT in Google Sheets: multiply numeric factors or ranges together instead of adding them or summing row-wise products. Includes worked examples and application-specific cautions.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Google Sheets. How formula examples are checked
Quick answer: Use PRODUCT in Google Sheets to multiply numeric factors or ranges together instead of adding them or summing row-wise products. The official PRODUCT reference is the source for the function definition and platform-specific rules described below.
Syntax and arguments
=PRODUCT(factor1, [factor2, ...])
factor1 (required): The first number or range of factors.
additional factors (optional): Other numbers or ranges to include in the same multiplication.
Square brackets mark optional arguments; do not type those brackets into the example formulas. Examples use English function names, comma argument separators and decimal points. Adapt formula separators to your workbook settings, not punctuation inside quoted text.
When to use it
Use PRODUCT for a sequence of factors, a volume calculation or repeated scaling. Use SUMPRODUCT when each row has a quantity-times-unit-value calculation and the desired answer is the sum of those row results. Multiplying every cell in both columns is a different operation.
Three worked examples
Each example is independent. Where input cells are listed, enter those values first; otherwise the formula is self-contained. Expected outputs are independently checked calculations or documented error expectations, not captured results from Google Sheets.
Example 1: Calculate a rectangular volume
| Cell | Enter as a number |
|---|---|
| B2 | 5 |
| B3 | 4 |
| B4 | 3 |
=PRODUCT(B2:B4)
Expected result: 60.
The numeric dimensions are 5, 4 and 3 in the same unit. Their product is 60 cubic units.
Example 2: Apply a scaling factor
=PRODUCT(12,0.5,3)
Expected result: 18.
Half of 12 is 6 and multiplying by 3 gives 18. This is one chain of factors, not a sum.
Example 3: Retain an explicit zero factor
=PRODUCT(5,4,0)
Expected result: 0.
The final zero controls the whole product. A deliberately entered zero is not treated as an empty cell.
Put it to work safely
Label every factor and keep its units visible. For a rectangular volume, all three lengths must use the same unit before multiplying. Include deliberate zero and negative test values during validation so a missing or incorrectly signed factor is not hidden. A product of several factors can grow or shrink rapidly; check that the intended model is multiplicative.
Common mistakes and fixes
The answer becomes zero. A numeric zero is a real factor, not a blank. Any included zero makes this product zero.
The total is vastly larger than expected. You may need a sum of per-row products, not one product of the entire range. Review whether SUMPRODUCT matches the task.
Missing inputs are not obvious. Some range inputs can be ignored rather than treated as numeric zero. Validate required fields separately before interpreting the result.
Google Sheets-specific notes
Google documents range inputs and ignored empty cells. Although the syntax notes mention 30 factors, the same help page says more arguments are supported. Do not turn the displayed argument numbering into a false 30-factor compatibility limit. See the vendor reference for the current definition.
Excel and Google Sheets comparison
The explicit numeric factors here provide straightforward comparison cases. Blank, text, logical and error-containing ranges need application-specific tests, as do large argument lists.
Compare the PRODUCT guide for Microsoft Excel and its official documentation. Having a guide in both libraries establishes two documented references, not a certificate of identical behavior across releases, locales or file conversions.
Related guides
Evidence and testing scope
Editorial verification: Official references retrieved on 2026-10-12. The three worked cases are included in this release’s reproducible Python checking suite. It checks the stated arithmetic, calendar or text model and the expected documented error classification; it is not the Google Sheets calculation engine. No native application run, UI screenshot, maximum-size benchmark or cross-version certification is claimed. Review the editorial testing standards before relying on a formula in a critical workbook.