Google Sheets Function: SUM

The SUM function calculates the sum of a series of values, often used to obtain the total of a cell range.

Usage:

=SUM(range)

or

=SUM(value_1, value_2, etc)


Usage Example

Simply enter the cell range you want to sum up in the SUM function.

In some cases, Google Sheets will suggest a pre-filled SUM formula that you can use if the proposed range is correct:

google sheets sum function png

=SUM(B2:B11)

The sum is then displayed:

google sheets sum

Sum of Multiple Ranges or Cells

To get the sum of several cell ranges (or individual cells), add them in sequence:

=SUM(A2:A11,B2:B6,C2)
google sheets multiple sums sum