PRODUCT function
PRODUCT multiplies a list of numbers or a range together and returns the result. It is useful for compounding growth factors, and blank cells and text inside ranges are ignored.
Example
Read it as a sentence: multiply all the numbers in A1:A5 together, which gives 120.
Excel shows 120
A
1
1
2
2
3
3
4
4
5
5
Data
Syntax
PRODUCT(number1, [number2], ...)
Arguments in [square brackets] are optional.
-
number1(required) - The first number or range.
-
[number2], ...(optional) - More numbers or ranges.
Returns: All the inputs multiplied together.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=PRODUCT(1,2,3) | 6 | Scalars |
=PRODUCT({1,2,3}) | 6 | Array constant |
=PRODUCT("2",3) | 6 | Text number arg counted |
=PRODUCT(TRUE,3) | 3 | TRUE arg counted |
=PRODUCT({1,"2",TRUE}) | 1 | Array with text |
=PRODUCT(Data!A1:A5) | 120 | Range |
=PRODUCT("a",3) | #VALUE! | Text arg |
=PRODUCT(1E+200,1E+200) | #NUM! | Overflow |
The Data sheet these formulas read
A cell that starts with = holds that formula.
A
1
1
2
2
3
3
4
4
5
5
Data
Watch out for
- Blank cells and text inside ranges are ignored.
- An all-empty range returns 0.
Where it works
- Excel
- PRODUCT is in every version of Excel from 2007 on.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Math and trig functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .