Last Updated on
If you want to learn how to add numbers in Excel, we’ve got you covered.
Excel is all about sorting data, and there can be times when you’re dealing with a lot of numbers. In these situations, you may need to add numbers for some purpose. If you’re new to Excel, you may find the process of adding numbers in Excel a bit tricky. However, it is actually quite easy, and there are multiple ways to do it.
In this guide, we will talk about how to add numbers in Excel and will share a total of five methods that can help you save a lot of time.
How to add numbers with the = symbol
The first, and most basic, method of adding numbers in Excel is by using the = symbol.
Select a cell
First, select a cell and type “=” in it.
Type the numbers and press enter
Next, type the numbers (=23+11), and press Enter.
How to add numbers from different cells
If you want to add numbers from different cells, here are the steps you need to follow.
Select an empty cell
Select an empty cell. This will be the one where the results will appear.
Type the cells and press enter
Next, type “=” in the cells and this time, instead of typing numbers, type the cells. For example, type =D2+D3 and press Enter.
How to add numbers using SUM function
The SUM function allows you to select cells instead of typing numbers, and here’s how you can use it.
Use the SUM formula
First, select a cell, an empty one, and type =SUM. Next, add a bracket after it and then type the cell numbers. It should look like this:
Once done, press Enter, and the numbers within the selected cells with get added.
How to add numbers using AutoSUM
AutoSUM is a great way to add numbers, as it lets you do it with just a click of a button.
Select the cells
First, select cells containing numbers. You can either select rows or columns, as the AutoSUM feature works with both of them.
Click on AutoSum
Now, go to the Home tab, and click on AutoSUM.
Once done, the numbers will get added, and the result will either appear below the cells or on the right side (if you were adding a row of numbers).
How to add numbers using SUMIF function
This method is meant for complex situations, where you want to set a certain criteria.
Select an empty cell
First, select an empty cell and type =SUMIF.
Complete the formula
Now, you need to type the cells you need to add, and then select a criteria. For instance, we want to add the numbers from D2 to D6. However, we only want to add numbers that are less than 9. So we will type =SUMIF(D2:D6,”<9″).
Once done, press Enter, and this will be the result.
As you can see, Excel added every number, but ignored 11 as it was greater than 9.
This was everything you needed to know about how to add numbers in Excel. As you can see for yourself, the process of adding numbers is pretty simple, and you’ll be able to do it quickly once you get the hang of everything. We shared a total of five methods, and each can prove to be useful in a different kind of situation.
Learn more about Excel through these guides: