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.

Two ways to insert a graph or chart in Google Docs!
Michael Michael (174)

When you're writing a piece of content and want to demonstrate some facts or highlight data, then it makes sense to include a chart or graph right in your Google Doc.