SUM Function in Excel, Google Sheets, Airtable & Notion
SUM adds numbers together. In Excel and Google Sheets it can total whole ranges at once; in Airtable and Notion it adds the values of a single record or of a list.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | SUM(number1, [number2], ...) |
| Google Sheets | ✔ Built in | SUM(value1, [value2, ...]) |
| Airtable | ✔ Built in | SUM(number1, [number2, ...])Adds fields of one record, e.g. SUM({Q1}, {Q2}). To total many records use a rollup field with SUM(values). |
| Notion | ✔ Built in | sum(number | list, ...)Also written as a list method: prop("Amounts").sum(). |
| Excel | =SUM(A2:A5) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =SUM(A2:A5) | open sheets.new ↗ |
| Airtable | SUM(120, 80.5, -15, 42) | |
| Notion | sum([120, 80.5, -15, 42]) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Amount 120 80.5 -15 42
Arguments
| Argument | What it means |
|---|---|
number1 | The first number, cell, or range to add. |
[number2], ... optional | More numbers or ranges. Excel accepts up to 255 arguments. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=SUM(A2:A10) | Total of A2 to A10 | The most common form: one contiguous range. | |
=SUM(A2:A10, C2:C10) | Both columns | Separate several ranges with commas. | |
=SUM(1, 2, "3") | 6 | Text that looks like a number is converted when typed directly as an argument. | |
=SUM(B:B) | Whole column | Whole-column references grow automatically as rows are added. |
Examples use Excel / Google Sheets syntax unless noted.
How SUM works
SUM is the workhorse of every spreadsheet. It accepts any mix of numbers, cell references and ranges, adds everything that is a number, and quietly skips empty cells, text and logical values that live inside a range. That last point catches people out: a number stored as text (often from an import, shown left-aligned with a green triangle) is ignored by =SUM(A2:A10), so the total looks too small. Convert the cells with VALUE or Data → Text to Columns.
Airtable and Notion formulas see one record at a time, so SUM there adds a few fields of the same row. To total a column across many rows, use a rollup: in Airtable, a rollup field with the aggregation formula SUM(values); in Notion, a rollup set to Sum or a formula like prop("Line items").map(current.prop("Amount")).sum().
If any cell in the range contains an error such as #N/A, SUM returns that error too. Wrap the range in IFERROR inside an array formula, or use AGGREGATE(9, 6, A2:A10) in Excel to sum while ignoring errors.