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
=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