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.
Version
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:
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 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.