SUM Function in Apple Numbers: Syntax, Examples, and Common Errors
Total a collection of numeric values with worked examples and practical troubleshooting.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Apple Numbers. How formula examples are checked
Quick answer
SUM helps you total a collection of numeric values. In Numbers, start a formula with an equals sign and use the function browser if you want to select reference cells rather than typing their addresses.
Syntax and arguments
=SUM(value, …)
value is a numeric value, cell reference, or range; additional values or ranges may be supplied.
Numbers shows comma-separated arguments in its English documentation. For locales with a decimal comma, use semicolons as function argument separators. Enter references by selecting the correct cells or table columns.
Example: a five-row sales table
Create a table named Sales with headers in row 1 and the following data in rows 2–6:
| Row | A: Region | B: Amount |
|---|---|---|
| 2 | East | 120 |
| 3 | West | 75 |
| 4 | East | 90 |
| 5 | West | 115 |
| 6 | East | 35 |
Enter the formula in a result cell in the same table:
=SUM(B2:B6)
Expected result: 435. Add B2:B6: 120 + 75 + 90 + 115 + 35 = 435.
Advanced example
=SUMIF(A2:A6,"East",B2:B6)
Expected result: 245. You can put the criterion in a separate cell instead of editing a formula every time; for example replace the quoted category with a selected criterion cell reference.
Mistakes and edge cases
Text labels are not sales amounts. Ensure imported amounts are numeric; confirm the cell format and visually check unexpected blank or zero results.
If the total is wrong, inspect the source range, omitted rows and values stored as text. If the result is a formula error, reselect the intended range using the formula editor.
A common source of confusion is referencing a different table: Numbers table names can appear in a reference, so use the editor to select the actual source range.
Cross-software compatibility
SUM works similarly in Excel, LibreOffice Calc and Google Sheets, but Numbers uses table references such as Sales::B2:B6 when referencing another table. Do not assume every cross-table reference looks like Excel’s worksheet syntax.
Related tutorials
Official reference and verification
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.