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 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.
Version 
Usage notes 

The Excel PRODUCT function returns the product of numbers provided as arguments. Because it can accept a range of cells as an argument, PRODUCT is useful when multiplying many cells together

The PRODUCT function takes multiple arguments in the form number1, number2, number3, etc. up to 255 total. Arguments can be a hardcoded constant, a cell reference, or a range. All numbers in the arguments provided are multiplied together. Empty cells and text values are ignored.

Examples

The PRODUCT function returns the product of supplied arguments:

=PRODUCT(3,8) // returns 24
=PRODUCT(3,8,4) // returns 96

PRODUCT multiplies all numeric values together, so the following formulas are equivalent:

=PRODUCT(A1:A5)
=PRODUCT(A1,A2,A3,A4,A5)
=PRODUCT(A1:A2,A3:A5)

PRODUCT ignores text values and empty cells. The formulas below will return the same result with all cells have numeric values:

=PRODUCT(A1:A5)
=A1*A2*A3*A4*A5

However, the second formula will return zero (0) if any cells are empty, and a #VALUE! error if any cells contain text.

Notes

  • Numbers can be supplied individually or in ranges.
  • PRODUCT can accept up to 255 arguments total.
  • Only numbers in the array or reference are multiplied.
  • Empty cells, logical values, and text in the array or reference are ignored.

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.