Exceljet

Quick, clean, and to the point

Excel PRODUCT Function

Excel PRODUCT function
Summary 
The Excel PRODUCT function returns the product of numbers provided as arguments. The PRODUCT function is helpful when when multiplying many cells together. The formula =PRODUCT(A1:A3) is the same as =A1*A2*A3.
Purpose 
Get the product of supplied numbers
Return value 
Product of supplied numbers
Syntax 
=PRODUCT (number1, [number2], ...)
Arguments 
  • number1 - The first number or range to multiply.
  • number2 - [optional] The second number or range to multiply.
Usage notes 

The Excel PRODUCT function returns the product of numbers provided as arguments. The PRODUCT function is useful when when multiplying many cells together.  The following formulas all return the same result:

=PRODUCT(A1:A3)
=PRODUCT(A1,A2,A3)
=A1*A2*A3

Notes

  1. Numbers can be supplied individually or in ranges.
  2. PRODUCT can accept up to 255 arguments total.
  3. Only numbers in the array or reference are multiplied.
  4. Empty cells, logical values, and text in the array or reference are ignored.
Related functions 
Excel SUM function
Excel SUM Function

The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments.

Excel SUMPRODUCT function
Excel SUMPRODUCT Function

The SUMPRODUCT function multiplies ranges or arrays together and returns the sum of products. This sounds boring, but SUMPRODUCT is an incredibly versatile function that can be used to count and sum like COUNTIFS or SUMIFS, but with more...

500 Formula Examples, thoughtfully explained.