Multiply every factor in sight — ranges, scalars, or both. The contrast table shows where PRODUCT diverges from SUM, and the three rules (zero kills, ranges skip, overlaps double) that surprise people.
Returns the product of all numeric factors. One zero factor makes the result 0.
Same numbers, two aggregates. Plus the three rules that make PRODUCT behave unlike SUM: zero kills, ranges skip text and blanks, overlapping ranges double-count.
| Expression | Result | Why |
|---|---|---|
| =PRODUCT(2,3,4) | 24 | PRODUCT: multiply the factors |
| =SUM(2,3,4) | 9 | SUM: add the terms — different aggregate |
| =2*3*4 | 24 | Operator form: identical to PRODUCT for scalars |
| =PRODUCT(2,3,0) | 0 | One zero factor annihilates the product |
| =SUM(2,3,0) | 5 | SUM ignores zero's special role — it is just a term |
| =PRODUCT(A2:C2,2) | 48 | Ranges and scalars mix freely: 24×2 |
| =PRODUCT(A2:C2,A2:C2) | 576 | Overlapping ranges multiply twice: 24×24 |
All presets are exact and engine-stable. Edit the grid factors and every gallery row recomputes live.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
PRODUCT is universal across every Excel version and Google Sheets; identical to the * operator for scalar factors.
| Platform | Support | Notes | Gotcha |
|---|
PRODUCT is one piece. The full course walks the toolkit end to end with live, measured examples.