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

John John (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. As an Amazon Associate, we may earn a small affiliate commission at no cost to you when you buy through our links.

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!

You can easily convert a PDF to a Google Doc, then save it.
Michael Michael (175)

To save a PDF as a Google Doc, it must first be converted via Google Drive. We're actually impressed by how easily PDFs become Google Docs and how much of the formatting gets retained.