Related Functions:
 AVERAGE function
 POWER function
 SUM function
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

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 (True1; 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 