The Excel PRODUCT Function

Basic Description

The Excel PRODUCT function returns the product (multiplication) of a supplied set of numerical values.

The syntax of the function is:

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

where the number arguments are a set of numbers (or arrays of numbers) that you want to calculate the product of.

In current versions of Excel (Excel 2007 and later), you can enter up to 255 number arguments to the Excel Product function, but in Excel 2003, the function will only accept up to 30 arguments. However, each argument can consist of an array of values or a range of cells, each of which can contain many values.


Which Values are Included in the Excel Product Function Calculation?

Numbers and dates are always counted as numeric values by the Excel Product function. However, text and logical values are handled differently, depending on whether they are values stored in the cells of your spreadsheet, or they are supplied directly to the function.

The table below shows which values are included in the Excel Product Function calculation, and which values are ignored or produce errors:

Value Within a
Range of Cells
Value Supplied
Directly to Function
NumbersIncludedIncluded
DatesIncludedIncluded
Logical ValuesIgnoredIncluded
(True=1; False=0)
Text Representations of
Numbers & Dates
IgnoredIncluded
Other TextIgnored#VALUE! Error
ErrorsErrorError

Excel Product Function Examples

Cells B1-B5 of the following spreadsheet show five examples of the Excel Product function.

In each case, the function is used to calculate the product of the numbers 3, 6, 2, 8 & 5, but each of the five examples, the numbers are supplied to the function in a different way.

 Formulas:
 AB
13=PRODUCT( 3, 6, 2, 8, 5 )
26=PRODUCT( {3,6,2}, 8, 5 )
32=PRODUCT( A1, A2, A3, A4, A5 )
48=PRODUCT( A1, A2, A3, "8", "5" )
55=PRODUCT( A1:A5 )
 Results:
 AB
131440
261440
321440
481440
551440

Note that, in the above example spreadsheet:

Further examples of the Excel Product function are provided on the Microsoft Office website.


Product Function Error

If you get an error from the Excel Product Function, this is likely to be the #VALUE! error:

Common Error
#VALUE!-Occurs if any of the arguments that are supplied directly to the Product function can not be interpreted as numeric values.