Arguments
number1- The first number or range to add.number2(optional) - Additional numbers or ranges.
SUM
Adds all the numbers in one or more ranges.
Syntax
=SUM(number1, [number2], …)=SUM(B2:B100)Returns: Total of the range
The most common aggregation.
=SUM(B2:B10, D2:D10)Returns: Combined total of two ranges
SUM accepts several ranges at once.
Common Errors and Gotchas
- Numbers stored as text are ignored - they'll be left-aligned and excluded from the total.
- For conditional totals, use SUMIF or SUMIFS.
Does SUM Work in Google Sheets?
Yes. SUM uses the same syntax in Google Sheets and LibreOffice Calc, so you can paste these formulas straight across.