Matias Delacroix/Getty Images
You can sum numbers in Excel automatically or manually.
- It's easy to sum in Excel in two different ways to add a series of numbers together.
- You can add two or more numbers using the AutoSum tool, or by manually totaling them with plus signs.
- The AutoSum tool automatically selects a series of nearby numbers, but you can select any set of numbers by clicking and dragging with the mouse.
- You can see the details of the calculation by clicking the cell with the sum and looking at the formula bar at the top of the screen.
- Visit Business Insider's homepage for more stories.
You can sum a series of numbers in Excel manually or automatically using the AutoSum tool in the ribbon.
Both methods will always give you the same result, so you can use whichever one is more convenient.
Transform talent with learning that worksCapability development is critical for businesses who want to push the envelope of innovation.Discover how business leaders are strategizing around building talent capabilities and empowering employee transformation.Know More Here's how to do it.
Check out the products mentioned in this article:
How to use AutoSum in Excel
AutoSum works best when you have a column or row of numbers you want to add.
1. Click the cell under a column of numbers you want to add. Or, if you want to sum a row of numbers, click the cell to the right of the series.
2. On the Home tab, click the AutoSum button (which looks like a sigma sign) in the ribbon.
Steven John/Business Insider
You'll have to click on the Sigma sign to Autosum.
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.
Dave Johnson/Business Insider
The Autosum tool automatically selects the nearest row or column of numbers, but you can change it before you press Enter.
3. Press Enter on your PC keyboard, or Return if you're using a Mac.
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 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.
Dave Johnson/Business Insider
You can sum numbers or cells by creating a sum formula manually.
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.
Insider receives a commission when you buy through our links.
Next Story
Global stocks rally even as Sensex, Nifty fall sharply on Friday
In second consecutive week of decline, forex kitty drops $2.28 bn to $640.33 bn
SBI Life Q4 profit rises 4% to ₹811 crore
IMD predicts severe heatwave conditions over East, South Peninsular India for next five days
COVID lockdown-related school disruptions will continue to worsen students’ exam results into the 2030s: study
