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.




=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


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:

google sheets multiple sums sum