1. Open your Google Sheet and identify the column to total
In Google Sheets, find the column with the numeric values you want to add—such as spend, lead count, or revenue.
2. Select an empty cell for the sum result
Click on an empty cell at the bottom of the column or elsewhere in the sheet where you want the total to appear.
3. Enter the SUM formula for your column
Type =SUM(B2:B100) to add all values in column B from rows 2 to 100. Adjust the range as needed based on where your data ends.
4. Press Enter to display the total
Google Sheets will calculate and display the total sum in the selected cell.
5. (Optional) Use column letter shortcut to sum the whole column
To total the entire column, you can use =SUM(B:B)—but be cautious of header rows or non-numeric values that may affect accuracy.
