How to Total a Column in Google Sheets (SUM Function)

Totaling a column in Google Sheets is one of the most common tasks, and the SUM function is the quickest and most reliable way to do it. This guide shows you exactly how to add up a column of numbers—whether it’s a short list or hundreds of rows—and gives you tips to avoid common mistakes.

What You’ll Need

• A Google Sheets document with the numbers you want to add.
• Basic familiarity with clicking cells and typing in the formula bar.
• An internet connection (Google Sheets is web-based).

Step-by-Step

1. Open your Google Sheet in a web browser. If you don’t have one yet, go to sheets.new to create a blank spreadsheet.
2. Identify the column you want to total. For this example, we’ll use column A, with numbers in cells A1 through A10.
3. Click the cell where you want the total to appear. This is usually directly below the last number in the column (e.g., A11), but it can be anywhere—even on a different sheet.
4. Type the equals sign = in that cell. Every formula in Google Sheets starts with an equals sign.
5. Type SUM right after the equals sign, followed by an opening parenthesis: =SUM(. You’ll see a small suggestion box appear; you can click “SUM” there if you prefer.
6. Select the range of cells you want to add. Click the first cell in the column (e.g., A1), then drag down to the last cell (e.g., A10). As you drag, you’ll see a blue outline and the range will appear in the formula, like =SUM(A1:A10).
7. Type a closing parenthesis ) to finish the formula. It should look like =SUM(A1:A10).
8. Press Enter on your keyboard. The cell will now show the total of all numbers in that range.

That’s it! The SUM function adds up every numeric cell in the range, ignoring empty cells and text.

Common Mistakes

• Forgetting the equals sign: Typing SUM(A1:A10) without the = will just show the text, not calculate anything.
• Selecting the wrong range: If you accidentally include the cell where the total will go (e.g., A11), you’ll create a circular reference, and the formula will return 0 or an error.
• Including text or blank cells: SUM ignores text and blanks, so this isn’t usually a problem—but if you have numbers stored as text (e.g., with a currency symbol), they won’t be added. You’ll see the total is lower than expected.
• Using the wrong separator: In some regions, the argument separator is a semicolon (;) instead of a comma. If you type =SUM(A1,A10) and get an error, try =SUM(A1;A10).

Tips

• Use the toolbar shortcut: Click the cell below your column, then click the Σ (sigma) icon in the toolbar. Sheets will automatically guess the range and insert the SUM formula for you.
• Sum an entire column: You can use =SUM(A:A) to add up every number in column A, no matter how many rows you have. This is great for growing lists, but be careful not to put the formula in column A itself, or you’ll get a circular reference.
• Add multiple ranges: You can sum several columns at once: =SUM(A1:A10, C1:C10).
• Use keyboard shortcuts: Press Alt+Shift+= (Windows/ChromeOS) or Option+Shift+= (Mac) to insert a SUM formula for the selected range.
• Check the status bar: If you just want a quick total without a formula, select the cells and look at the bottom-right of the window—it shows the sum, average, and count.

Troubleshooting

If your SUM formula isn’t working as expected, try these steps:

• Check for a circular reference: If the formula cell is included in the range (e.g., you put =SUM(A1:A11) in cell A11), Sheets will show a warning. Remove the formula cell from the range or move the formula to a different cell.
• Look for text-formatted numbers: If a cell shows a number but is actually text (often indicated by a green triangle in the corner), SUM will ignore it. Select the cells, go to Format → Number → Automatic, or use =SUM(VALUE(A1:A10)) as an array formula (press Ctrl+Shift+Enter) to convert them.
• Verify the range: Click the cell with the formula and look at the colored outline. Make sure it covers exactly the cells you want.
• Check for hidden rows: SUM includes hidden rows. If you have filtered or hidden rows, the total will include them. If you want to sum only visible rows, use =SUBTOTAL(109, A1:A10) instead.
• See an error like #NAME?: This usually means you typed the function name incorrectly (e.g., SUMM). Double-check the spelling.

Frequently Asked Questions

Can I sum a column that has blank cells?

Yes. The SUM function ignores blank cells automatically, so you don’t need to do anything special.

How do I sum only visible cells after filtering?

Use =SUBTOTAL(109, A1:A10). The number 109 tells Sheets to sum only visible (unfiltered) rows.

What if I want to add numbers from different sheets?

You can reference other sheets in your formula: =SUM(Sheet2!A1:A10, Sheet3!A1:A10). Just replace the sheet names with your actual sheet names.

Why is my total showing as 0?

This usually means the cells you’re summing contain text, not numbers. Check if the cells are formatted as text or if they have leading apostrophes. Re-enter the numbers or use the VALUE function.

Can I sum an entire column without specifying a range?

Yes, use =SUM(A:A). This sums every cell in column A, but make sure the formula isn’t in column A itself.

Is there a faster way than typing the formula?

Yes, click the cell below your column, then press Alt+Shift+= (Windows) or Option+Shift+= (Mac). Sheets will automatically insert a SUM formula for the range above.

Related

• Recover Lost Missing Gmail Emails: Full Guide
• How to Gift and Redeem Discord Nitro: Desktop & Phone
• Driver Crashed and Was Reset? Meaning & Fix