The fastest way to add a column is the SUM function

Click on an empty cell below or beside the column you want to add. Type =SUM( then click the first cell in your column, hold Shift, and click the last cell. Type the closing parenthesis ) and press Enter. Excel adds all the numbers in that range and shows the total in your cell.

If your column is A2 through A10, you would type =SUM(A2:A10). The colon between the two cell references tells Excel to include everything in between. You can also type the range directly without clicking — both methods work the same way.

SUM ignores empty cells and text, so it will not break if your column has a few blanks or labels mixed in. It only adds actual numbers.

Key Takeaways

  • Click an empty cell, type =SUM(, select your range, close the parenthesis, and press Enter to add a column.
  • Use a colon between cell references to select a range — A2:A10 means every cell from A2 to A10.
  • SUM automatically ignores empty cells and text, so you do not need to clean up your data first.
  • You can drag the small square at the bottom right of a cell with a SUM formula down to copy it to other rows, which adjusts the range automatically.
  • If you need to add only cells that meet a condition — like numbers greater than 100 — use SUMIF instead of SUM.

Selecting your range by clicking and dragging

Instead of typing the cell references, you can click and drag to select the cells you want to add. Click on the first cell in your column, then hold down your mouse button and drag to the last cell. When you release, Excel shows the range in your formula bar.

This method is often faster if your column is short or if you can see all the cells on screen at once. For very long columns that scroll off the screen, typing the range directly is usually quicker because you do not have to scroll while holding the mouse button.

Adding multiple columns or non-adjacent cells

If you want to add cells that are not next to each other, use a comma to separate them. Type =SUM(A2:A10, C2:C10) to add column A and column C together. You can list as many ranges as you need, separated by commas.

You can also mix individual cells and ranges. =SUM(A2:A10, C5, D2:D10) adds the range A2 through A10, the single cell C5, and the range D2 through D10 all in one formula.

Copying a SUM formula to other cells

Once you have written a SUM formula in one cell, you can copy it down to calculate totals for other columns or rows. Click the cell with your formula, then look for the small square at the bottom right corner of the cell. Click and drag that square down or to the right to copy the formula.

Excel automatically adjusts the cell references as it copies. If your first formula was =SUM(A2:A10) and you drag it to the right, the next cell will show =SUM(B2:B10). This saves you from typing the formula over and over.

Using SUM with headers and labels

If your column has a header in the first row — like "Sales" or "Expenses" — start your range on the second row. Type =SUM(A2:A10) instead of =SUM(A1:A10) so the header text does not interfere with the calculation.

SUM will not break if you accidentally include the header, because it skips text automatically. However, starting your range below the header keeps your formula cleaner and makes it easier to read later.

When to use SUMIF instead of SUM

The basic SUM function adds every number in your range. If you only want to add numbers that meet a specific condition — like all sales over $500 or all expenses in a certain category — use SUMIF instead.

SUMIF takes three parts: the range to check, the condition, and the range to add. For example, =SUMIF(A2:A10, ">500", B2:B10) checks column A for values greater than 500, and if it finds them, adds the matching numbers from column B. This is useful when your data has multiple columns and you need to add only rows that match certain criteria.

Frequently Asked Questions

What if my column has negative numbers?

SUM adds negative numbers correctly — they subtract from the total. If you have $100, -$50, and $75, SUM will show $125. If you want to add only positive numbers or only negative numbers, use SUMIF with a condition like ">0" or "<0".

Can I use SUM on a column that has formulas in it?

Yes. SUM adds the results of formulas just like it adds regular numbers. If column A contains formulas that calculate individual sales, and you use =SUM(A2:A10), Excel adds up all those calculated results.

Why does my SUM formula show an error?

The most common cause is a typo in the cell references or a missing closing parenthesis. Check that your formula starts with =SUM( and ends with ). Also make sure the cells you are trying to add actually contain numbers, not text that looks like numbers.

How do I add a column that keeps growing as I add new rows?

Instead of specifying an exact range like A2:A10, use a larger range that covers more rows than you currently have, like A2:A1000. As you add new data, the SUM formula automatically includes it. Alternatively, use the entire column reference =SUM(A:A), though this includes the header if you have one.

Can I see the total without creating a formula?

Yes. Select the cells you want to add, and look at the bottom right of your screen in the status bar. Excel shows the sum, average, and count of the selected cells automatically, without you needing to write a formula.