How to Add Up Columns in Google Sheets (Step-by-Step Guide)

Adding up columns in Google Sheets is one of those basic skills that unlocks a lot of power: budgets, gradebooks, sales reports, inventory tracking, time logs, and more. The good news is that you don’t need to be a spreadsheet expert to do it. Google Sheets gives you a few simple tools to total a column, and you can pick the one that fits how you work.

Below, we’ll walk through the main methods, what they do, and when they’re useful, so you can decide how to handle your own sheet.

The Core Idea: How Column Sums Work in Google Sheets

At its simplest, “adding up a column” in Google Sheets means using a formula that takes all the numbers in a range of cells and returns a single total.

The usual building block for this is the SUM function: