PRODUCT Function in Apple Numbers: Multiply values, ranges and quantities

=PRODUCT(num-value, num-value…)

Apple’s version 15.4 Functions Help reference gives this function name, argument order and argument types; checked on 2026-10-11.

All parameters shown as required above must be supplied; only arguments explicitly labelled optional may be omitted. Enter = before the function. Apple writes argument lists with commas in its English help; when the user’s decimal separator is a comma, Apple says to type semicolons between function arguments. This does not change any cell values, and a one-argument function has no separator to change. See Apple’s functions syntax guide.

Version and device scope: The specific documentation URL is the Apple 15.4 Functions Help page. Apple describes the in-app Functions Browser for Numbers on Mac, iPhone and iPad, and for iWork apps on iCloud.com (official welcome). That help entry does not establish the first Numbers release that supported this function, nor that every historical macOS/iOS/iPadOS/web edition handles every edge case identically. No first-supported version has been invented; native version-by-version testing is still pending.

Numbers references: Examples below enter formulas in the same table as the data, so B2, C2, and B2:D2 are legitimate Numbers cell references. For references into a different table, Apple documents forms such as Table Name::B2 or Sheet Name::Table Name::B2; use the formula editor to select cross-table cells (Apple cell references).

Use PRODUCT to calculate a box’s volume from three dimensions, multiply a rate by multiple adjustments, or check a series of factors without building a long B2*C2*D2 expression. PRODUCT is multiplication, not addition: Numbers documents SUM separately. Apple’s PRODUCT reference explicitly says that empty cells inside the included values are ignored.

Create a table called Packages. Make row 1 a header and enter these exact values:

In cell E2 of the same table, type:

=PRODUCT(B2:D2)

Expected result: 24 cubic centimetres, since 2 × 3 × 4 = 24. Format E2 as a number, not text, if you want a numeric result. Copy E2 into E3 and E4; with normal relative references, the formulas refer to B3:D3 and B4:D4, and the expected results are 40 and 90. The units are implied by your source data—PRODUCT itself returns a number, not a unit label. Cell-reference guidance supports relative references in copied formulas.

How to reproduce: Click E2; begin with =; select or type the function and three-cell range; confirm the calculation. You can click the range rather than manually typing its characters, especially when the column header names replace letters in the edited formula.

Suppose a warehouse stores two identical packages in one carton and you want total enclosed volume. In F2, enter:

=PRODUCT(B2:D2,2)

Expected result: 48 cm³, because the 24 cm³ single-box volume is multiplied by 2. You could instead store the carton quantity in G2 and use =PRODUCT(B2:D2,G2); with G2 set to 2 the result remains 48. The formula becomes reusable when a worker edits only G2.

For more than one kind of item whose rowwise quantities must be multiplied by rowwise prices and then added, PRODUCT alone is not that aggregation; see Apple’s SUMPRODUCT documentation. Use SUMIFS for a conditional sum, not a product.

• Zero factor: =PRODUCT(3,0,7) is mathematically 0; all factors still count.
• Negative factor: =PRODUCT(-2,3) is mathematically −6. Two negative factors instead give a positive product.
• Blank input: Apple’s PRODUCT page explicitly states that an empty cell inside the provided collection is ignored. It does not mean a missing measurement should silently be treated as 1 in a safety-critical volume calculation. Check the completeness of your input rows before using the result.
• Imported measurements: If a pasted value displays as text, verify its cell format and conversion before expecting it to be included in numerical calculations. Apple warns about imported numeric text under formula best practices.
• Unexpected large/small answer: Check whether a quantity or price has been included twice. Multiplying a percentage displayed as 10% is not necessarily the same as multiplying by 1.10. A 10% increase requires a multiplier of 1.10.
• Broken reference: If a row or column is removed, inspect the red error indicator rather than silently substituting a guess. Ensure the output cell is outside the input range to avoid circular references.

Excel and Google Sheets use a PRODUCT function for numerical multiplication too, and * expresses multiplication in all three tools. Do not assume copied formulas retain exactly the same table qualifiers: Numbers refers to another table using forms such as Packages::B2 where needed; Excel often uses workbook/worksheet notation instead. Preserve intended numeric inputs during imports and verify their display formats and actual stored values. The example above is documented as Numbers-specific, not an Excel screenshot.

• SUMIFS guide already in Spreadsheet-Tutorials.com — adding only rows meeting criteria, not multiplying factors.
• Apple SUM function — adding values.
• Apple SUMPRODUCT function — summing products of corresponding cells.

• Apple Numbers — function documentation
• Apple’s functions syntax guide
• official welcome
• Apple cell references
• SUM
• SUMPRODUCT
• formula best practices

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.