Article updated on April 20, 2018

The PRODUCT function returns the product of the numbers given in the argument.

Formula in cell D3:


Excel Function Syntax

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


number1 Required. The number you want to multiply.
[number2] Optional. Additional numbers you want to multiply.


You don't need to use a comma delimiting character between each number, simply supply the cell reference to all numbers in the first argument.

Empty cells, boolean values and text values are ignored.

The product function allows you to have up to 254 arguments.

=PRODUCT(B3:D3, B9:D9) is the same as =B3*C3*D3*B9*C9*D9