PRODUCT Function in Excel: Multiply Many Numbers

⏱ 1 min readUpdated 28 September 2026

MathLevel: BeginnerAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Example 2
  5. Related functions

PRODUCT multiplies all numbers in its arguments, ignoring text and blanks.

Syntax

=PRODUCT(number1, [number2], ...)
Argument What it means
number1… Numbers or ranges.

Examples

Example 1

=PRODUCT(B2:D2)

Length × width × height.

Example 2

=PRODUCT(1+B2:B13)-1

Compound growth from 12 monthly returns (Excel 365, or Ctrl+Shift+Enter).

SUMPRODUCT · POWER

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZT Function in Excel: Keep Text, Blank Out NumbersExcel Functions A–ZPDURATION Function in Excel: Years Needed to Reach a TargetExcel Functions A–ZTEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong