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:

=SUM(C6:C12)

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!

Let the past stay in the past on Google Chrome!
Britt Britt (156)
2 minutes

If you’re anything like me, you tend to open up multiple tabs at a time when working on a project.