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.

Tip: If you need to sum columns or rows of numbers next to each other, use AutoSum to sum numbers. Give it a try. If you want to play around with our sample data, here’s some data to use. You can see how the SUM function works by copying the following table into a worksheet and pasting it into cell A1. Need more help?

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.

Use Excel as your calculator. Add and subtract numbers. Multiply and divide numbers. Calculation operators and order of operations. Enter a series of numbers, dates, or other items. To add a list of numbers, select the cell below a column of numbers, and then click AutoSum.

Select an empty cell directly above or below the range that you want to sum, and on the Home or Formula tabs on the Ribbon, press 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.

Use AutoSum. You can use AutoSum to quickly sum a column or row or numbers. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter (Windows) or Return (Mac), and that's it! When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.