Quick Navigation

PRODUCT Function

Excel 2007+

Summary

The Excel PRODUCT function multiplies all supplied numbers or cell ranges together and returns the result. It's perfect for calculating totals from multiple values without typing lengthy multiplication formulas.

Syntax

PRODUCT(number1, [number2], ...)

Parameters

Parameter	Type	Required	Description
number1	`Number/Range`	Yes	The first number, cell reference, or range to multiply
number2	`Number/Range`	No	Optional additional numbers, cell references, or ranges to include in multiplication (up to 254 more arguments)

Using the PRODUCT Function

PRODUCT simplifies multiplying multiple values together. Instead of writing long multiplication chains like =A1*A2*A3*A4*A5, you can use =PRODUCT(A1:A5) to multiply an entire range at once. The function automatically skips non-numeric values.

Common PRODUCT Examples

Basic Range Multiplication

=PRODUCT(A2:A4)

Multiplies all numbers in cells A2 through A4 (5 × 15 × 30 = 2250)

Range with Constant

=PRODUCT(A2:A4, 2)

Multiplies range A2:A4 and then multiplies result by 2 (2250 × 2 = 4500)

Multiple Individual Cells

=PRODUCT(B1, C3, E7, 10)

Multiplies specific cells B1, C3, E7 and the constant 10

Ignoring Non-Numbers

=PRODUCT(A1:A10)

Skips any text, blanks, or TRUE/FALSE values in the range

Frequently Asked Questions

Yes, PRODUCT automatically ignores empty cells, text values, and logical values (TRUE/FALSE), multiplying only numeric values.

Up to 255 arguments total, including the required first argument.

Absolutely. PRODUCT works perfectly with cell ranges like A1:A10 or multiple ranges like A1:A5, C1:C5.

Common Errors and Solutions

#VALUE! error

Cause: All arguments contain only text or no numbers

Solution: Ensure at least one argument contains numeric values

Unexpected results

Cause: Non-numeric values in ranges being ignored

Solution: Verify which cells contain the numbers you expect to multiply

Notes

Only numbers contribute to the result - text, blanks, TRUE/FALSE are skipped
Zero in any argument returns 0 as the product
Very large products may display in scientific notation
Use SUMPRODUCT for array-based conditional multiplication

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in:

Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+