How to Sum in Google Sheets: Quick Total and SUM Formula

Adding up a column of numbers in your head is a good way to get it wrong. Google Sheets will do the adding for you, and there are two ways to do it: a quick look at the bottom of the screen, or a SUM formula that stays in your sheet.

I've taken the details from Google's own pages for the SUM function and for seeing a quick total, so what follows matches what Google documents.

The quickest way to sum in Google Sheets: highlight the cells

If you only need an answer and don't want to leave anything behind, use the built-in total:

1. Open your spreadsheet in Google Sheets in a desktop browser.
2. Select the cells you want to add together.
3. Look at the bottom-right corner of the window, where Sheets shows Sum: followed by the total.

Google adds one warning: this feature doesn't work for some numbers or number formats. If you see no total, or it looks wrong, the SUM formula below is the safer route.

Typing the SUM function in a Google Sheets cell

To put the total in a cell, start with an equals sign. Google's help says to type an equal sign (=) in a cell and type in the function you want to use. Then:

1. Click the cell where you want the answer.
2. Type =SUM( and then select the range of cells to add, or type it in.
3. Close the bracket and press Enter.

As you type, Sheets shows a help box with the function's definition, syntax and an example, according to Google. It can also suggest formulas and ranges based on your data, which you can accept or ignore.

How the SUM formula in Google Sheets is built

Google writes the syntax as SUM(value1, [value2, ...]). The first value is a number or range to add. The extra values are optional, and each can be another number or range. Google's own examples show how flexible that is:

Example from Google's help	What it adds
SUM(A2:A100)	Every number in cells A2 down to A100
SUM(1,2,3,4,5)	The five numbers typed in directly
SUM(1,2,A2:A50)	The numbers 1 and 2, plus everything in A2 to A50

Two more details from the same page. If you give SUM only a single number, it just returns that number. And although SUM is specified as taking a maximum of 30 arguments, Google says Google Sheets supports an arbitrary number of arguments, so you don't need to worry about running out.

Summing several separate ranges in Google Sheets

Because SUM accepts extra values, you can add blocks that aren't next to each other. Put a comma between them, such as one range for this quarter's orders and another for last quarter's. The formula returns a single total across all of them.

Keep an eye on what's inside your ranges. Sums are only as good as the cells you select, so if a number was typed with stray text or spaces, check it's stored as a number before you trust the total.

Using SUM in Google Sheets for everyday business jobs

• Adding up hours worked by a freelancer across a week.
• Totalling the units sold for each product line.
• Counting up expenses you've logged in a single column.
• Combining several tabs' totals into a summary cell.

If you're building a reusable Sheet, the thinking in my guide to choosing a productivity template helps you decide how much to automate. And for documents that need a total at the bottom, filling in a Google Docs template correctly shows how I keep layouts tidy.

Keeping a Google Sheets sum right as your list grows

A total that's right today can quietly go wrong once new rows land outside the range. A simple habit helps: keep the total at the bottom, insert new rows above it rather than below, and check the range in the formula still reaches the last entry. Click the total cell and read the formula to see exactly which cells it covers. If a colleague has added data, that's the first place I'd look when a number seems low.

Summing on a phone with the Google Sheets app

Google has a quick-total page for Android too, but I couldn't confirm its exact steps from the official page, so I won't guess. The reliable approach on any device is the formula: tap the cell, type =SUM( and choose your range.

If your Google Sheets sum looks wrong

1. Check the range. Did you select every cell you meant to?
2. Look for numbers stored as text, which are often left-aligned and may be skipped or misread.
3. Check for hidden rows inside the range, because a hidden row can still hold a number.
4. Try the quick total at the bottom-right as a second opinion, bearing in mind Google says it doesn't work for some numbers or formats.
5. Re-enter the formula from scratch if you copied it from somewhere else.

Frequently asked questions

How do I sum a column in Google Sheets?

Click the cell for your answer, type =SUM( then select the column's cells and press Enter. For a quick look without a formula, select the cells and read Sum at the bottom right.

What is the syntax for SUM in Google Sheets?

Google writes it as SUM(value1, [value2, ...]), where the first value is a number or range and the others are optional.

Is there a limit on how many values SUM can take?

Google says SUM is specified as taking a maximum of 30 arguments, but Google Sheets supports an arbitrary number of arguments.

Why doesn't the total appear at the bottom right?

Google notes that this feature doesn't work for some numbers or number formats. Use the SUM formula instead.

What does SUM return for a single number?

If you supply only a single number as value1, SUM returns that number.