The SUM function adds a range of cells in one step

The fastest way to add numbers in Excel is the SUM function. Instead of typing =A1+A2+A3+A4, you type =SUM(A1:A4) and get the same answer. Excel reads the colon as "through," so A1:A4 means "add every cell from A1 to A4."

You can sum a column, a row, or any rectangular block of cells. The function works the same way whether you have 5 numbers or 500. Once you type the formula and press Enter, Excel calculates the total and updates it automatically if you change any of the numbers inside.

Key Takeaways

  • Type =SUM(A1:A10) to add cells A1 through A10; the colon tells Excel to include everything in between.
  • Click the first cell you want to add, hold Shift, and click the last cell to select the range without typing it manually.
  • SUM ignores empty cells and text, so it only adds numbers even if your range includes other data.
  • You can sum multiple separate ranges in one formula: =SUM(A1:A5,C1:C5) adds two different blocks.
  • The AutoSum button (Σ symbol) on the toolbar finds and fills in the range for you in most cases.

How to type a SUM formula step by step

Click the cell where you want the total to appear. This is usually below or to the right of the numbers you are adding. Type an equals sign (=) to start a formula, then type SUM, then an opening parenthesis.

Type the first cell you want to add, a colon, and the last cell. For example, if your numbers are in cells A1 through A10, type A1:A10. Then type a closing parenthesis and press Enter. Excel calculates the sum and shows the result in that cell.

The formula bar at the top of the screen shows what you typed. If you click the cell again later, you can see the formula and edit it. The cell itself shows only the number, not the formula.

Selecting the range without typing it

You do not have to type the cell addresses. Click the cell where you want the total, type =SUM(, then click the first cell you want to add. Hold Shift and click the last cell in the range. Excel highlights all the cells in between and fills in the addresses for you.

This method is faster and less error-prone, especially with large ranges. You can see exactly which cells you are including because they light up on the screen. When you are done selecting, type the closing parenthesis and press Enter.

Using the AutoSum button for quick totals

The AutoSum button is the Greek letter sigma (Σ) on the toolbar, usually in the top right area. Click the cell where you want the total, then click AutoSum. Excel guesses which cells you want to add based on where your numbers are and inserts a SUM formula automatically.

Most of the time, Excel gets it right. If it selects the wrong range, you can click and drag to adjust before pressing Enter. This is the fastest route if your numbers are in a straightforward column or row with no gaps.

Adding multiple separate ranges in one formula

Sometimes your numbers are not all in one block. You might have one group in cells A1:A5 and another in C1:C5. Type =SUM(A1:A5,C1:C5) with a comma between the ranges. Excel adds all numbers in both blocks.

You can include as many separate ranges as you need. Each range goes in parentheses or separated by commas, depending on your version of Excel. This is useful when your data is organized in columns that are not next to each other.

What SUM ignores and why that matters

SUM only adds numbers. If a cell contains text, a blank space, or a formula that produces text, SUM skips it. This means you can safely use SUM on a range that includes labels or empty cells without getting an error.

If you want to count how many cells have numbers instead of adding them, use COUNTA or COUNT instead. If you want to add only cells that meet a certain condition—like numbers greater than 100—use SUMIF. But for straightforward addition, SUM handles mixed content without complaint.

Fixing common SUM mistakes

The most common error is typing the range backwards, like =SUM(A10:A1). Excel still works, but it is confusing to read. Always type the first cell, then the colon, then the last cell.

Another mistake is forgetting the colon. =SUM(A1 A10) will not work; Excel needs the colon to know you mean a range. If you see an error message like #NAME?, check that you spelled SUM correctly and included the parentheses.

If your total seems wrong, click the cell and look at the formula bar to confirm which range you included. You might have missed a row or included a header row by accident. Adjust the range and press Enter to recalculate.

Frequently Asked Questions

Can I use SUM on cells in different sheets?

Yes. Type =SUM(Sheet1.A1:A10,Sheet2.A1:A10) to add ranges from multiple sheets. The syntax varies slightly by version, but the idea is the same: name the sheet, then a period, then the range. Check your version's help if the period does not work.

What is the difference between SUM and TOTAL?

Excel has SUM, not TOTAL. If you type =TOTAL(), you will get an error. SUM is the function that adds numbers. Some other programs use TOTAL, but in Excel, always use SUM.

Does SUM work on cells with formulas in them?

Yes. SUM adds the results of formulas, not the formulas themselves. If cell A1 contains =5+3, SUM treats A1 as 8 and adds it normally. This is how most spreadsheets work together—formulas feed into other formulas.

Can I sum only cells that match a condition?

SUM adds everything in the range. To add only cells greater than 100, or only cells that say "approved," use SUMIF instead. SUMIF takes three parts: the range to check, the condition, and the range to add.

What happens if I delete a number in the range?

The total updates automatically. If you had =SUM(A1:A10) and delete the number in A5, the formula still covers A1:A10, but A5 is now empty, so it contributes zero. The total recalculates when ready.