Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inPRODUCT(number1, [number2], ...)
Google Sheets✔ Built inPRODUCT(factor1, [factor2, ...])
Airtable≈ Workaroundnumber1 * number2 * ...
Airtable has no PRODUCT function; multiply fields with *.
Notion≈ Workaroundnumber1 * number2 * ...
Notion has no product(); multiply with *.
Try PRODUCT with your own values
One value per line, or separate with commas
Result (as Excel & Google Sheets return it)
30
Your formula, ready to paste
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

ArgumentWhat it means
number1The first number or range to multiply.
[number2], ... optionalAdditional numbers or ranges.

Examples

FormulaResultWhyCopy
=PRODUCT(A2:A4)A2 × A3 × A4Multiplies every number in the range.
=PRODUCT(2, 3, 4)24
=PRODUCT(A2:A4, 100)… × 100Mix 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.

Part of the Math & Rounding functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.