# PRODUCT function in Excel

> PRODUCT multiplies all of its arguments together.

Source: https://spreadsheetpractice.com/functions/product · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** PRODUCT multiplies all of its arguments together.
- **Syntax:** `=PRODUCT(number1, [number2], ...)`
- **Most common use:** `=PRODUCT(B2:D2)` returns $37.80 (Quantity × price × discount factor from one range)
- **Available in:** Every current version
- **Category:** [Math functions](https://spreadsheetpractice.com/functions/category/math)
- **Returns:** Every number in the arguments multiplied together.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

PRODUCT multiplies all of its arguments together. It's a shorter way to write =B2*C2*D2 when several cells in a row are factors, such as quantity, price and a discount multiplier. Empty cells and text inside a range are skipped rather than treated as zero.

## Syntax

`=PRODUCT(number1, [number2], ...)`

| Argument | Required? | What it is |
|---|---|---|
| `number1` | Required | The first number, cell or range to multiply. |
| `number2` | Optional | More numbers, cells or ranges to multiply in. You can list up to 255. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| E2 | `=PRODUCT(B2:D2)` | $37.80 | Quantity × price × discount factor from one range |
| E3 | `=PRODUCT(B3:D3)` | $50.00 | The empty discount cell is skipped, not treated as zero |
| E4 | `=PRODUCT(B4:C4,D4)` | $40.80 | Ranges and single cells can be mixed in one formula |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Item | Qty | Unit price | Discount factor | Line total |
| 2 | Notebooks | 12 | $3.50 | 0.9 | $37.80 |
| 3 | Pens | 40 | $1.25 |  | $50.00 |
| 4 | Binders | 6 | $8.00 | 0.85 | $40.80 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| The result is far too big | The range includes a cell you didn't mean to multiply, such as an ID, a year or a running total. Select only the factors. |
| Expected 0 but got a number | PRODUCT skips blank cells and text instead of multiplying by zero. If a blank should mean zero, multiply the cells directly: =B2*C2*D2. |
| #VALUE! | A typed argument is text that isn't a number, such as =PRODUCT(B2,"n/a"). Point to cells instead, or remove the text. |

## Tips

- To multiply row by row and then total the results, use SUMPRODUCT instead of a PRODUCT column plus a SUM.

## Related functions

- [SUMPRODUCT](https://spreadsheetpractice.com/functions/sumproduct): SUMPRODUCT multiplies matching items in two or more ranges and adds the results.
- [SUM](https://spreadsheetpractice.com/functions/sum): SUM adds numbers.
- [POWER](https://spreadsheetpractice.com/functions/power): POWER raises a number to a power, the same as the ^ operator.

## Questions

### How do I multiply cells in Excel?

Use * for two or three cells, such as =B2*C2, or =PRODUCT(B2:D2) to multiply everything in a range.

### What is the difference between PRODUCT and SUMPRODUCT?

PRODUCT multiplies every number together into one result. SUMPRODUCT multiplies matching rows of two or more ranges and adds those results, which is what you want for units × price totals.

### Does PRODUCT treat blank cells as zero?

No. Blank cells and text inside a range are ignored. If every cell is blank, PRODUCT returns 0.

## Practice

A graded PRODUCT exercise ("Price each part") is on [the PRODUCT page](https://spreadsheetpractice.com/functions/product). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
