PRODUCT Function in Microsoft Excel: Examples, Pitfalls & Compatibility
PRODUCT in Microsoft Excel: 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 Microsoft Excel. How formula examples are checked
Quick answer: Use PRODUCT in Microsoft Excel 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(number1, [number2], ...)
number1 (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 Microsoft Excel.
Example 1: Multiply three dimensions
| Cell | Enter as a number |
|---|---|
| B2 | 6 |
| B3 | 4 |
| B4 | 3 |
=PRODUCT(B2:B4)
Expected result: 72.
The three dimensions give 6 × 4 × 3 = 72 cubic units. Enter the values as numbers, not unit-labelled text.
Example 2: Include a zero factor
=PRODUCT(6,0,3)
Expected result: 0.
Zero is multiplied rather than ignored. Investigate whether the zero is a valid measurement or a data-entry problem.
Example 3: Check two negative factors
=PRODUCT(-2,-3,4)
Expected result: 24.
The two negative signs cancel, then the result is multiplied by 4.
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.
Microsoft Excel-specific notes
Excel documents up to 255 arguments and says that only numeric values in an array or reference are multiplied; referenced text, logical values and empty cells are ignored. That should not be generalized to every directly supplied argument or error. 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 Google Sheets 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 Microsoft Excel 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.