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

Formula in cell D3:

=PRODUCT(B3:C3)

Excel Function Syntax

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

Arguments

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

Comments

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