Syntax
=PRODUCT(factor1, [factor2, ...])
factor1- The first number, cell or range to multiply.
factor2, ...- Optional. More numbers or ranges.
PRODUCT function in Google Sheets
PRODUCT multiplies all the numbers you give it. It's handy when you need to multiply a whole range together and typing a chain of * signs would be tedious.
Practice PRODUCT
Task 1 of 1
Calculate the volume of the first box by multiplying length, width and height with PRODUCT. Answer in E2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
PRODUCT examples
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | |
|---|---|---|
| 1 | Value | Other |
| 2 | -7.45 | 3 |
| 3 | 12.5 | 4 |
| 4 | 81 | 2 |
| 5 | 2.5 | 0 |
| 6 | 1234.567 | 5 |
| Formula | Result | What it shows |
|---|---|---|
=PRODUCT(B2:B3) | 12 | Multiplies every number in the range. |
=PRODUCT(A3, B3) | 50 | Same as =A3*B3. |
=PRODUCT(B2:B6) | 0 | One zero in the range makes the whole result zero. |
Tips and common mistakes
- Blank cells in a range are skipped, not treated as zero.
- For multiplying matching pairs of numbers and adding the results (price × quantity totals), Google Sheets has SUMPRODUCT.
Related functions
Learning step by step? PRODUCT is covered in Lesson 32: MEDIAN, MOD, ABS & More Math of the free course.