Math · aggregates · Nov 2026

PRODUCT.

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.

D1
fx
=PRODUCT(factors)
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How PRODUCT works

Returns the product of all numeric factors. One zero factor makes the result 0.

=PRODUCT(number1, [number2], …)
number1A number, range, or expression contributing factors.
number2…More factors. Ranges skip text/blanks; scalars must be numeric. Overlaps multiply twice.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
contrast

Multiply vs add — the aggregate contrast

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.

ExpressionResultWhy
=PRODUCT(2,3,4)24PRODUCT: multiply the factors
=SUM(2,3,4)9SUM: add the terms — different aggregate
=2*3*424Operator form: identical to PRODUCT for scalars
=PRODUCT(2,3,0)0One zero factor annihilates the product
=SUM(2,3,0)5SUM ignores zero's special role — it is just a term
=PRODUCT(A2:C2,2)48Ranges and scalars mix freely: 24×2
=PRODUCT(A2:C2,A2:C2)576Overlapping ranges multiply twice: 24×24
⚠ Inside a RANGE, text and blanks are silently skipped — but as a SCALAR argument, text raises #VALUE!. And overlapping ranges are not deduplicated: PRODUCT(A2:C2,A2:C2) squares the row.
Use PRODUCT for compounding factors (growth rates, unit conversions, probabilities). Use SUM for additive terms. A single zero in a product is a signal, not noise — check whether it belongs there.
// 03 — Try it live

Interactive PRODUCT playground

All presets are exact and engine-stable. Edit the grid factors and every gallery row recomputes live.

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

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.

// 05 — Cross-platform

Where PRODUCT works

PRODUCT is universal across every Excel version and Google Sheets; identical to the * operator for scalar factors.

PlatformSupportNotesGotcha
✓ Supported full PRODUCT◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master multiplication

PRODUCT is one piece. The full course walks the toolkit end to end with live, measured examples.

  • PRODUCT vs repeated multiplication
  • Zero, blank and text rules
  • Overlapping ranges multiply twice
  • Scalar text raises #VALUE!
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked