Google Sheets Function

SUM

Add up a range of numbers.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

SUM(number1, [number2], …)

SUM totals the numbers in one or more ranges or individual cells — the most-used function in Excel. It ignores text and blanks, so a stray label in a column won't break the total.

Arguments

number1requiredThe first number, cell, or range to add.
number2…optionalAdditional numbers or ranges.

Examples

=SUM(B2:B100)

Result: $248,500

Adds every number in the range.

=SUM(B2:B10, D2:D10)

Result: 1,420

Totals two separate ranges at once.

FAQ

Why does SUM show 0?

The numbers are likely stored as text. Convert them with VALUE or by multiplying by 1, and SUM will pick them up.

Related functions

SUMIF SUMIFS AVERAGE