![]() ![]() Method-3: Utilizing SUM Function to Add Multiple Cells in Excel Read More: How to Sum Selected Cells in Excel (4 Easy Methods) Then the total amount will show up in Cell C10. Now click on the second cell and repeat till all the cells add up.Click on the first cell to add and type the Plus ( +) sign.First, select Cell C10 and type the Equal ( =) sign.Now we are going to add simply all the salary cells to get the total salary in Cell C10. Method-2: Applying Algebraic Formula to Add Multiple Cells in Excel Read More: How to Add Specific Cells in Excel (5 Simple Ways) You can also do this by going to the Formulas tab > AutoSum.Īnd, the final result will be the same as the previous one.Now the result is showing in the required cell. In Cell C10, a formula appears and points to the cells we want to add.Next from the Editing group of commands, click on AutoSum.First, click Cell C10, and then go to the Home tab.Now we are going to add the total working days. Suppose we have a table of people’s names and their working days. By clicking on the AutoSum option, Excel will automatically add multiple cells by entering the SUM function. The easiest way to add multiple cells is using the AutoSum feature. Method-1: Use of AutoSum Feature to Add Multiple Cells in Excel However, you can use any other version at your convenience. Using this dataset we will demonstrate different easy methods to add multiple cells in Excel.įor creating this article, we have used Microsoft Excel 365 version. Here, we have a list of some names of employees of a company and their corresponding working days with their salaries. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |