PRODUCT Function
Multiplies numbers, cells and ranges together.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A number
Want to practice PRODUCT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
PRODUCT multiplies everything you give it — the multiplication version of SUM.
It's handy for compounding: multiply a column of growth factors to get the total growth.
Syntax
=PRODUCT(number1, [number2], …)
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number1 | Yes | A number, cell or range to multiply. |
| number2, … | Optional | Up to 254 more. |
Examples
Example 1 — Compound growth
Northstar grew 5%, 8% and −2% in three years. Multiply the growth factors.
C2fx=PRODUCT(B2:B4)-1
| A | B | C | |
|---|---|---|---|
| 1 | Year | Factor | Total growth |
| 2 | 2024 | 1.05 | 0.11132 |
| 3 | 2025 | 1.08 | |
| 4 | 2026 | 0.98 |
=PRODUCT(B2:B4)-1 Explain
Format C2 as a percentage: 11.1% total growth.
Common mistakes
- Empty cells are skipped, not zero. A blank in the range doesn't turn the answer into 0 — it's ignored.
Notes
- Related functions: SUM, SUMPRODUCT, POWER.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.