Microsoft Excel is one of the largest numeric data manipulation software in the world. We can perform all the mathematical operations in Excel. It provides us with the built-in tools and functions to sum up numeric data.
In this tutorial we’ll learn how to add a cell’s value in MS Excel. We have two different ways to add/sum up the cell’s numeric data.
Method 1 – Using sum formula
Microsoft Excel provides us a built-in formula to sum data in specific data range
To sum we have given formula
=SUM(number1 , number 2 , …..)
We can add more than 1 number by using the above-mentioned formula. In most cases we have a big data range with thousands of data cells that we need to get summed up. This formula really helps. Below are the steps to follow.
Step 1 – Select the cell and use formula
- Select any empty cell.
- Type the formula. In this case, we have 1020 cells in the G column. We will type =SUM(G2:G1021). It will select all data ranges starting from cell G2 and ending at G1021.
- Close the bracket and press enter key.
- As soon as you press the enter key, it will sum all the selected data range.
Method 2 – Use auto sum function
This method allows us to add numeric data automatically by a single click.
Below are the steps to follow.
Step 1 – Press auto sum button
- Go to the Home tab.
- In the Editing cluster, there is a summation symbol button. The default selected function is SUM. By using the drop down menu we can perform other functions too.
- Select the data range that you wish to sum up.
- Press the auto sum button.
- As soon as you press the enter key it will sum all the data range and provide the result in the cell above.
Hence, we can add cells in excel by above mentioned methods.
Bonus tip: If we select all the data ranges, excel will automatically show the sum , average and count in the bottom right corner of the status bar.