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!

Google's powerful suite of tools makes copying text from images or PDFs a complete breeze!
Odin Odin (60)
5 minutes

We've all been there before: we have one copy of some vital document to which there is no editable, digital copy.