Google sheet allows you to use many functions on a data set. Functions are convenient mathematical operations that can convert raw data into usable information. One such function is the SUM function, which lets you sum up numeric data in a column.

**Formula for the SUM Function**

The SUM Function totals the values of specific cells, a particular row or column. To use the SUM function, you may use the following formula:

**= SUM(A1: A5)**: Sums cells A1 **through **A5

OR

**=SUM(A1, A5): **Sums cells A1 **and **A5

Here are a few things you should remember while using the SUM function:

**1. The word SUM denotes the function name. The bracket () encapsulates the cells in a row or a column that contain the numeric data.**

**2. The cell reference before the ‘:’ denotes the cell from which the summation begins.**

**3. ‘:’ allows you to input a range of adjacent cells, and ‘,’ allows you to input non-consecutive cells. **

**4. The cell after the semicolon denotes the cell where the summation ends.**

## 3 ways to sum a column in Google Sheets

**Method 1: Manually type the formula in the cell****Method 2: Using the Insert Function Option****Method 3: SUM a Column on a Cellular Device**