1
Click here
Click here
Calculate Column Sum in Google Sheets
How to use the sum function in Google Sheets
Accounting & Finance
2
Press Cmd + ↑
Press Cmd + ↑
3
Press Cmd + ↓ and Select the entire column you want to sum
Press Cmd + ↓ and Select the entire column you want to sum
4
Click the Functions button
Click the Functions button in the top toolbar to open the list of available formulas.
5
Select the SUM option
Click "SUM" from the functions dropdown menu to calculate the total of the selected cells.
6
Press Enter
Press Enter
7
There you go - your data is summed!
There you go - your data is summed!
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.