How to sum values in Excel automatically using the AutoSum tool, or manually with the SUM function

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically by using the AutoSum tool in the toolbar on your screen. 

Both methods will always give you the same result, so use whichever one is more convenient for you.

Here's how to do it on a Mac or PC computer. 

Check out the products mentioned in this article:

Apple Macbook Pro (From $1,299.00 at Apple)

Acer Chromebook 15 (From $179.99 at Walmart)

iPhone 11 (From $699.99 at Apple)

Samsung Galaxy S10 (From $699.99 at Walmart)

How to use AutoSum in Excel

AutoSum works best when you have a column or row of numbers you want to add up.

1. Click the empty cell underneath the column of numbers that you want to add up. Or, if you want to sum a row of numbers, click the empty cell to the right of the series.

2. On the "Home" tab, click the AutoSum button (which looks like a sigma sign) in the toolbar at the top of your screen.

3. You should see Excel draw a selection box around the numbers to be added. If the wrong numbers are selected, you can click and drag the mouse to choose the correct cells.

3. Press "Enter" on your PC keyboard, or "Return" if you're using a Mac.

Your cells don't have to be laid out consecutively in a row or column to be added up — instead of dragging down a columb or across a row, you can also click on non-consecutive cells throughout your spreadsheet before hitting "Return" or "Enter" on your keyboard. 

How to manually sum in Excel

1. Click the cell you want the sum to appear in and click "=."

2. Type a number or click a cell that has a value.

3. Type "+."

4. Type another number or click the next cell that has a value.

5. Repeat until you have entered all the values you want to sum, and then press "Enter" on a PC keyboard or "Return" on a Mac keyboard. 

To check your work, click the cell with the sum and look at the formula bar atop the screen. It will show the details of the calculation.

Related coverage from Tech Reference:

• How to convert your Google Sheets files into Excel files, and edit them in Microsoft Excel
  

• How to export your iPhone contacts to an Excel spreadsheet using iCloud

• How to copy a formula in Microsoft Excel using a Mac or PC

• How to edit a drop-down list in Excel, depending on how you created it

• How to combine 2 columns in Excel using formulas, and keep all of their data