Multiply every number in a range together in one step.
Copy this formula
=PRODUCT(A2:A10)PRODUCT multiplies all the numbers in the given ranges — the multiplication counterpart of SUM. It's useful for compounding factors, probabilities, and growth multipliers.
=PRODUCT(1+B2:B5)→1.61Compounds a column of growth rates.
Yes — it ignores text and empty cells, multiplying only the numbers.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.