How to Get the Sum of a Column in a Google Drive Spreadsheet

Tyler Tyler (304)
1 minute

This is a very simple guide on how to get the sum of a column in a Google Docs spreadsheet. If you have a list of numbers you want to add, here's how.

Google Drive Account×1

Howchoo is reader-supported. When you buy through links on our site, we may earn a small affiliate commission at no cost to you.

In Google Drive spreadsheets and many other spreadsheets you can add a column of numbers by placing the following code in a cell:


This will take all the numbers in cells C6-C12, add them, and put the sum in the cell where you placed the code.

If you found this useful, visit this guide to see how you can view the latest list of keyboard shortcuts in Google Sheets and optimize your workflow!

Everything you need is in one tab!
Britt Britt (12)

Using Google Workspace over other paid alternatives is one of the smarter moves for anyone who needs an easy-to-use and accessible suite of tools.