How to add in Excel: a step-by-step guideKnowing how to add in Excel can be a useful skill. This MS Word processing program can really do a lot of useful things, and adding is one of the most popular functions it provides. Do not let this Excel ability betray you with its simple looks. You will be surprised to discover how much it can help you. Microsoft Excel is one of those applications that can do a lot of things. It is quite possible that if you work with it every day, you will discover more and more possibilities, benefits, and handy tricks. It is time to make yourself familiar to the sum formula, one of those mathematical and trigonometrical functions that can be found in this processing program. Adding numbers in this MS processing program is much less complicated than it may seem. This spreadsheet developed by Microsoft will help you a lot if you master this function. Read also How to check 9mobile data balance: 4 ways you will love! The following one is the simplest and quickest way on how to add numbers in Excel that are already entered into cells within the same column or a row. Make use of the AutoSum button. Everything you need to do is: Read also Flash Fill Excel: Find out how to use it quite easily READ ALSO: How to recover unsaved Word document Sometimes, the cells may be not included automatically. In such a situation, you need to extend the frame over these cells in order to select them. One more simple and really fast adding option is hidden at the bottom edge of every Excel window. When you need to know the total sum of some values in a column, click the letter that marks the necessary column. Find the green Excel Status bar at the very bottom of the window, and you will see the sum. Remember, however, that you cannot copy a digit from this bar. You can also type the function in manually. The syntax of this function is rather simple: =SUM(number1, [number2],…) The required argument in this Excel sum formula is only one, and it is number1. The rest are optional and depend on how many values you want to add. The arguments can be represented by cell reference as in the example above where the single argument includes all the necessary cells, A1 through A4. Read also Master the concept of how to multiply in Excel with our easy guide This option allows one to calculate the sum of huge columns without selecting the whole range. Remember, though, that this way of adding includes hidden cells and filtered ones too. Use it by entering =SUM(…) into the blank bottom cell of a column within your range or into the blank cell to the right of a row. Filters may be helpful if you have several groups of values within your range. Selecting only the ones you need to calculate will save you a lot of time. Read also A step by step guideline of how spell check in Excel works You know already how to sum a column in Excel. If you have a range of cells with specific values within them, you can calculate the Grand Total for this whole range. To do it, complete the following steps: These are only the simplest ways of adding in Excel. The software can handle other, much more tricky adding operations that are very specific. If you are not an accountant or a finance expert, you may not need them. Still, it may be interesting to learn how they work and what they can do. Read also Top tips on how to add error bars in Excel in Windows and Mac These are simple basic instructions on how to add in Excel. Hopefully, this guide was helpful to you. READ ALSO: How to find and remove duplicates Excel: tutorial Source: Legit.ng Knowing how to add in Excel can be a useful skill. This MS Word processing program can really do a lot of useful things, and adding is one of the most popular functions it provides. Do not let this Excel ability betray you with its simple looks. You will be surprised to discover how much it can help you. Step 1: Step 2: Step 3: Step 4: READ ALSO =SUM(number1, [number2],…) Step 1: Step 2: Step 3: Step 4: Step 5: Step 1: Step 2: READ ALSO