PRODUCT Function in Excel, Google Sheets, Airtable & Notion
PRODUCT multiplies all of its arguments together. It is the multiplication equivalent of SUM and is handy when you need to multiply a whole range.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | PRODUCT(number1, [number2], ...) |
| Google Sheets | ✔ Built in | PRODUCT(factor1, [factor2, ...]) |
| Airtable | ≈ Workaround | number1 * number2 * ...Airtable has no PRODUCT function; multiply fields with *. |
| Notion | ≈ Workaround | number1 * number2 * ...Notion has no product(); multiply with *. |
| Excel | =PRODUCT(A2:A4) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =PRODUCT(A2:A4) | open sheets.new ↗ |
| Airtable workaround | 4 * 2.5 * 3 | |
| Notion workaround | 4 * 2.5 * 3 |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Factor 4 2.5 3
Arguments
| Argument | What it means |
|---|---|
number1 | The first number or range to multiply. |
[number2], ... optional | Additional numbers or ranges. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=PRODUCT(A2:A4) | A2 × A3 × A4 | Multiplies every number in the range. | |
=PRODUCT(2, 3, 4) | 24 | ||
=PRODUCT(A2:A4, 100) | … × 100 | Mix ranges and constants. |
Examples use Excel / Google Sheets syntax unless noted.
How PRODUCT works
PRODUCT is equivalent to writing =A2*A3*A4, but it accepts ranges and, like SUM, ignores empty cells and text inside them. That difference matters: =A2*A3 treats an empty A3 as 0 and returns 0, while =PRODUCT(A2:A3) skips the blank and returns A2.
A common use is compounding growth rates: if B2:B5 hold growth factors such as 1.05, 0.98 and 1.10, =PRODUCT(B2:B5) is the total growth over the whole period. To multiply two ranges element by element and add the results, use SUMPRODUCT instead.
Airtable and Notion have no PRODUCT function, so write the multiplication out with *. In Notion you can multiply a list from a relation with a map and repeated multiplication, but for a handful of properties prop("A") * prop("B") is simplest.
Frequently Asked Questions
- What does PRODUCT return for an empty range?
- Excel and Google Sheets return 0 when there are no numbers at all to multiply.