PRODUCT
Multiplies all the numbers given as arguments and returns the product.
PRODUCT(number1, [number2], ...)Arguments
number1First number or rangenumber2Additional numbers(optional)
=PRODUCT(2,3,4)2 x 3 x 4
=PRODUCT(A1:A5)Product of range
=PRODUCT(1+Rates)Compound multiple rates
- •Empty cells and text are ignored
- •Useful for compound growth calculations
- •Equivalent to multiplying all values together
- •Assuming PRODUCT ignores empty cells the way SUM does - it actually does ignore them (treats them as if absent, not as zero), but people sometimes assume the opposite and expect a result of 0 when a range includes blanks
- •Using PRODUCT on a range that includes text, expecting it to multiply through and ignore it - text is genuinely ignored, but a single 0 anywhere in the range will still zero out the entire result
- •Manually multiplying cells with the * operator across a long list instead of using PRODUCT, making the formula far longer and harder to maintain than necessary
SUMAdds values instead of multiplying them, sharing the same basic 'aggregate a range' structure as PRODUCT.SUMPRODUCTMultiplies corresponding elements of arrays together and then sums the results, a very different operation despite the similar name.POWERMultiplies a single value by itself repeatedly, useful when the same number needs to be part of a PRODUCT-style calculation.Does PRODUCT ignore empty cells?
Yes, empty cells are skipped entirely rather than treated as zero - only an actual 0 in the range will zero out the whole result.
Why did my PRODUCT formula return 0?
One of the cells in the range genuinely contains a 0 (or evaluates to it) - since multiplying by zero always gives zero, a single 0 anywhere in the range zeroes out the entire result.
Is PRODUCT the same as SUMPRODUCT?
No, despite the similar name - PRODUCT simply multiplies all the values in a range together, while SUMPRODUCT multiplies corresponding elements across multiple arrays and then adds up those results.
Need to translate a formula using PRODUCT?
Use our translator to convert your complete formula