FormulaCraft

PRODUCT

PRODUCT multiplies every number in the ranges you give it. It is cleaner than chaining * operators when multiplying many cells, such as compounding factors.

Excel
=PRODUCT(A2:A4)
Google Sheets
=PRODUCT(A2:A4)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

Value
2
3
4

=PRODUCT(A2:A4)→24

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2:A4 is the range of numbers.
  2. 2PRODUCT multiplies them all: 2 × 3 × 4.
  3. 3The result is 24.

Need a version for your data?

Try: “Multiply all the numbers in column A together”

Related

SUMIFSUMIFSCOUNTIF

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: