The fastest way to sum a column

Open your Google Sheet and click on the empty cell directly below the numbers you want to add. Type =SUM( and then click on the first number in the column. Hold Shift and click on the last number. Google Sheets will highlight the range in blue. Type the closing parenthesis ) and press Enter. The total appears in that cell.

If your numbers are in column B from row 2 to row 10, the formula looks like this: =SUM(B2:B10). The colon between the two cell names tells Google Sheets to add everything in between.

You can also type the range by hand instead of clicking. Both methods work the same way — Google Sheets adds up all the numbers and shows you the result.

Key Takeaways

  • Click the empty cell below your column, type =SUM( and then select the range of numbers you want to add, then close with ) and press Enter.
  • The formula =SUM(B2:B10) adds all numbers from B2 through B10, and you can type this directly instead of clicking if you know the cell names.
  • Google Sheets updates the sum automatically if you change any of the numbers in the column.
  • You can sum multiple separate ranges in one formula by typing =SUM(B2:B5,B8:B10) to skip rows you do not want to include.

Summing non-consecutive rows

Sometimes your data has gaps. You might want to add up sales from January, March, and May but skip the months in between. Click the cell where you want the total and type =SUM( followed by the first range, then a comma, then the next range.

For example, =SUM(B2:B5,B8:B10,B15:B18) adds three separate sections of your column. Google Sheets treats the comma as "and also add this part." You can include as many ranges as you need in a single formula.

When the sum updates automatically

After you create a SUM formula, Google Sheets watches those cells. If you change any number in the range, the total recalculates when ready. You do not have to rewrite the formula or press Enter again — the sheet does the work for you.

This matters when you are building a budget or tracking expenses. You can enter new numbers as they come in, and the running total stays correct without any extra steps.

Summing an entire column without knowing the last row

If your data grows over time and you do not know where it ends, use the column letter alone. Type =SUM(B:B) to add every number in column B, from top to bottom. Google Sheets ignores text and empty cells, so it only adds the actual numbers.

Be careful with this approach if your column has a header row with a number in it — Google Sheets will add that too. If your header is text like "Sales" or "Total," it gets ignored and causes no problem. If your header is a number like "2024," it gets included in the sum, which is usually not what you want.

Summing rows instead of columns

The same formula works sideways. If your numbers run left to right across a row instead of up and down a column, click the empty cell to the right of the last number and type =SUM(B2:E2) to add all numbers from B2 through E2 in that row.

The logic is identical — you are still telling Google Sheets which cells to add. The only difference is that the range goes across instead of down.

Troubleshooting when the sum shows zero or an error

If your formula returns 0 when you expected a larger number, check that the cells actually contain numbers and not text that looks like numbers. A number typed as text will not add up. Look for numbers that are left-aligned in their cells instead of right-aligned — that usually means they are stored as text.

If you see #ERROR! or #VALUE!, the formula itself has a problem. Common mistakes are a missing closing parenthesis, a space in the middle of a cell name, or a range written backwards like B10:B2 instead of B2:B10. Rewrite the formula carefully and try again.

If the cell shows a formula instead of a result — like you see =SUM(B2:B10) printed out — the cell is formatted as text. Right-click the cell, choose "Format cells," and change it to "Number" or "Automatic."

Frequently Asked Questions

Can I sum a column that has both numbers and text in it?

Yes. Google Sheets adds only the numbers and ignores the text. If a cell contains both, like "Sales: 150," Google Sheets treats it as text and skips it. Keep numbers in their own cells for reliable sums.

What is the difference between SUM and SUMIF?

SUM adds all numbers in a range. SUMIF adds only numbers that meet a condition — for example, =SUMIF(B:B,">100") adds only numbers greater than 100. Use SUM for straightforward totals and SUMIF when you need to filter.

Does the SUM formula work if I delete a row?

Yes. Google Sheets updates the formula automatically. If you delete a row inside the range, that number is no longer included in the sum. The formula stays the same but the result changes.

Can I sum multiple columns at once?

Yes. Type =SUM(B2:B10,C2:C10,D2:D10) to add three columns together. Or use =SUM(B2:D10) to add all numbers in the rectangle from B2 to D10, including all columns in between.