Learn simple ways to add in excel in this thorough article.
Excel really helps in a lot of things. Whether it is storing data, analyzing or doing calculations, everything can be done on it and that too in no time. Companies use it for all kinds of purposes and calculation is one of the. Calculating subtraction, addition, division, and multiplication are just a few examples of the many functions you can do.
How To Add In Excel
Let us learn in this article how to add in Excel.
How To Sum a Column In Excel
You can add many ways in Excel; one of the most common and easy ways is by using the “+” sign. You just need to specify the numbers you want to add before and after the + sign and Excel will give you the result.
Another amazing and super quick way to add in Excel is with the AutoSum feature which automatically detects the number range and gives you the sum of those numbers.
The third way is one of the most popular ways of adding numbers. It is the SUM feature in which you specify in a formula the cell ranges to add and Excel calculates the sum of those numbers for you.
Now we will look at each of these three ways closely.
How to Add Numbers Using the Plus Sign
To add numbers using the plus (+) sign, here are the steps:
1. Click the cell in which you want to display the result.
2. In that cell, type the following formula. Replace 5 and 10 in this formula with the numbers that you want to add.
3. Press Enter and it will display the result in your selected cell.
Instead of directly specifying numbers, you can also use the cell references in the above formula.
Also, edit a cell reference later so that you can quickly and easily change a number in an equation and immediately get an updated result.
Now, let’s add the numbers in the C2 and C3 cells and display the answer in the C5 cell.
Type this formula in C5 and then press Enter:
Your answer would be displayed in the C5 cell.
How to apply Round Off Formula in Excel
How to use If Formula in Excel
How to Add Numbers Using AutoSum
As discussed above, this feature automatically detects the range of numbers that you want to add and here is how to use it.
Click the cell next to where your numbers are placed. In the following example, it is the C8 cell.
Click the “Home” tab. In the “Editing” section, click the “AutoSum” icon.
Excel will automatically select your number range and now press Enter on your keyboard to get the sum.
You now have an answer in the C8 cell.
How to Add Numbers Using the SUM Function
This feature is the most popular way to add numbers to a spreadsheet and here is how you can use it.
Click the cell in which you want the result. In this example, click the C8 cell.
In this selected cell, type the following formula. This formula adds the numbers in the cells between C2 and C6. You can change this range to accommodate your numbers range.
Press Enter and the sum would be displayed.
This is how easy it is to add in Excel. These are 3 simple ways that you can make use of to do this and make your calculations super easy.
Microsoft Excel is made to simplify your life by enabling you to perform a wide range of tasks, from light ones like text wrapping to more intricate ones like concatenation in Excel. Anyone from any walk of life can benefit greatly from using Microsoft Excel.
In today’s fast-paced and ever-changing world, there is a high desire for shortcuts and improved methods to grasp and handle daily difficulties, which is where MS Excel comes in.
EasySheet is a tech blog where you can obtain incredible Excel hacks, tips, and tricks. Our main objective is to help beginners understand Excel with the EasySheet and get answers to all of their questions.
We are the best source of information for anyone in need of assistance with Microsoft Office products, including Excel, Word, PowerPoint, Publisher, and more!