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:
=SUM(B2:B11)
The sum is then displayed:
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)