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

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.

From the comedic to the breathtaking.
Michael Michael (130)

Note this is a PG-style list, which includes no nudity or violence. Making this list of the most unbelievable things caught by a Google street view camera has taught us one thing.