The fastest way: the SUM function

Click the empty cell below the column you want to add up. Type =SUM( then click the first number in the column, hold Shift, and click the last number. Type ) and press Enter. Excel adds them all up and shows the total in that cell.

If your column is A2 through A10, you can also type =SUM(A2:A10) directly. The colon tells Excel to include every cell between the first and last one you named. This method is faster once you know the exact range.

The SUM function ignores empty cells and text, so if one cell says "N/A" or is blank, Excel skips it and adds only the numbers. This is usually what you want.

Key Takeaways

  • The SUM function is the standard way to add a column: click below the numbers, type =SUM(, select the range, type ), and press Enter.
  • You can type the range directly as =SUM(A2:A10) if you know which cells hold your numbers, which is faster than clicking each one.
  • Excel ignores empty cells and text when using SUM, so a column with missing data or labels will still add correctly.
  • The total appears in the cell where you typed the formula, and you can copy that formula down to other columns or move it without retyping.

Selecting the range by clicking instead of typing

If you are not sure which cells to include, the click method is safer. Type =SUM( in the empty cell, then click and drag from the first number to the last. You will see the cells highlight in color as you drag. When you reach the bottom, release the mouse and type ), then press Enter.

Excel shows you the range as you select it, so you can see exactly which cells are included. This prevents mistakes if your column has gaps or if you are not sure where the data ends.

Adding only cells that meet a condition

If you want to add only numbers larger than 100, or only cells in a certain category, use SUMIF instead. The formula looks like =SUMIF(A2:A10,">100") to add only values greater than 100 in that range.

For more complex rules — like "add the sales only if the region is North" — use SUMIFS. The syntax is longer, but it works the same way: you name the range to add, then list your conditions. This is useful when your spreadsheet has multiple columns and you need to filter by more than one rule.

Copying the formula to other columns

Once you have typed the SUM formula in one cell, you do not have to retype it for every column. Click the cell with your formula, then drag the small square at the bottom right corner across to the next column. Excel copies the formula and adjusts the column letters automatically.

If your formula was =SUM(A2:A10), dragging it to the right creates =SUM(B2:B10) in the next column, then =SUM(C2:C10) in the one after that. This saves time when you have many columns to total.

Checking your work

Click the cell with your total and look at the formula bar at the top of the screen. You will see the formula you typed — for example, =SUM(A2:A10). This tells you which cells are being added. If the range is wrong, click the cell and edit the formula directly in the formula bar, or delete it and start over.

A quick sanity check: add a few numbers by hand to make sure the total makes sense. If the result seems too high or too low, the range might be wrong, or a cell might contain text instead of a number.

Using AutoSum for the fastest shortcut

Click the empty cell below your column of numbers. Look for the AutoSum button in the toolbar — it looks like a Greek sigma (Σ) symbol. Click it, and Excel guesses which cells you want to add and fills in the formula for you. Press Enter to accept it.

AutoSum works well if your numbers are in a continuous block with no gaps. If there are empty cells or text in the middle, AutoSum might stop too early or include cells you do not want. In those cases, check the formula bar and edit the range manually before pressing Enter.

Frequently Asked Questions

What if my column has text mixed in with numbers?

SUM ignores text and adds only the numbers. If a cell says "Total" or "N/A", Excel skips it. This is usually helpful, but if you want to count how many cells have numbers instead of adding them, use the COUNT function instead: =COUNT(A2:A10).

Can I add cells that are not next to each other?

Yes. Type =SUM(A2:A5,A10:A15) to add two separate ranges. Use a comma to separate the ranges. This works if your data is split across different sections of the spreadsheet.

Why does my formula show as text instead of a number?

The cell is probably formatted as text. Right-click the cell, choose Format Cells, and change it to Number. Then click the cell with your formula and press Enter again. Excel will recalculate and show the total.

How do I add a column that keeps growing?

Use a large range that covers more rows than you currently have: =SUM(A2:A1000). Empty cells do not affect the total, so this formula will still work correctly when you add more numbers later. You do not have to edit the formula each time.

Can I see the total without putting it in a cell?

Yes. Select the cells you want to add by clicking and dragging. Look at the bottom right of the screen in the status bar — Excel shows the sum, average, and count automatically. This is useful for a quick check, but the number disappears when you click elsewhere.