Related Functions:

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

Syntax

=PRODUCT(num_1,[num_2], … )

Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.

Arguments

Argument Description
num_1,
[num_2], …
The number arguments are a set of numbers (or arrays of numbers) that you want to find the product of

  Number arguments can be supplied to the function either directly, as values returned from other functions, or as references to cells containing numeric values

Values Counted as Numeric

Numbers and dates are always counted as numeric values by the Excel Product function. However, text representations 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.

    Value Within a Range of Cells  Value Supplied Directly to Function
Numbers   Included Included
Dates   Included Included
Logical Values   Ignored Included
(True-1; False=0)
Text Representations of Numbers & Dates   Ignored Included
Other Text   Ignored #VALUE! Error
Errors   Error Error

Examples

  A B C D D
1 Data   Formula Result Notes
2 3   =PRODUCT(3,6,2,8,5) 1,440 Arguments entered as individual numbers
3 6   =PRODUCT(A2:A6) 1,440 Multiplies the numbers in cells A2 through A6
4 2   =PRODUCT(A2:A6,2) 2,880 Multiplies the numbers in cells A2 through A6, then multiplies that result by 2
5 8   =PRODUCT(“3”,A3:A6) #VALUE! One of the numbers is a text string
6 5        

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments can not be interpreted as numeric values