If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you’re done. When you select AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. Here’s an example.

The AutoSum Wizard lets you easily add a SUM formula to your worksheet. Select an empty cell directly above or below the range to be summed. Then on the Home or Formula tab on the Ribbon, select AutoSum > Sum. The AutoSum Wizard will automatically sense the range to be summed and build the formula for you.

One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum. Excel will automatically sense the range to be summed. (AutoSum can also work horizontally if you select an empty cell to the right of the cells to be summed.)

Tip: If you need to sum columns or rows of numbers next to each other, use AutoSum to sum numbers.

To add a list of numbers, select the cell below a column of numbers, and then click AutoSum.

How to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.

Imagine each column in your table has a letter and each row has a number, like in a Microsoft Excel spreadsheet. For example, to multiply the numbers from the second and third columns in the second row, type =PRODUCT(B2:C2).

Excel inserts curly brackets at the beginning and end of the formula for you. For more information on array formulas, see Guidelines and examples of array formulas . Note: The above function will not only work for #VALUE!, but also for #N/A, #NULL, #DIV/0!, and others.

You can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in a drop-down list for each table column.

A fast way to do that is by using AutoSum. Select the cell to the right or below the numbers you want to add. Click the Home tab, and then click AutoSum in the Editing group. AutoSum adds up the numbers and shows the result in the cell you selected. For more information, see Use AutoSum to sum numbers