Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inSUM(number1, [number2], ...)
Google Sheets✔ Built inSUM(value1, [value2, ...])
Airtable✔ Built inSUM(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 insum(number | list, ...)
Also written as a list method: prop("Amounts").sum().
Try SUM with your own values
One value per line, or separate with commas
Result (as Excel & Google Sheets return it)
227.5
Your formula, ready to paste
Excel=SUM(A2:A5) open excel.new ↗
Google Sheets=SUM(A2:A5) open sheets.new ↗
AirtableSUM(120, 80.5, -15, 42)
Notionsum([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

ArgumentWhat it means
number1The first number, cell, or range to add.
[number2], ... optionalMore numbers or ranges. Excel accepts up to 255 arguments.

Examples

FormulaResultWhyCopy
=SUM(A2:A10)Total of A2 to A10The most common form: one contiguous range.
=SUM(A2:A10, C2:C10)Both columnsSeparate several ranges with commas.
=SUM(1, 2, "3")6Text that looks like a number is converted when typed directly as an argument.
=SUM(B:B)Whole columnWhole-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.

Frequently Asked Questions

Why does my SUM return 0?
The cells are probably text, not numbers. Text inside a range is ignored. Check alignment (text is left-aligned by default) or use =ISNUMBER(A2), then convert with VALUE or by multiplying by 1.
How do I sum only some rows?
Use SUMIF for one condition or SUMIFS for several.

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.