Select the range of cells by holding the shift key.Īfter selecting the range of cells to close the bracket and hit the enter button, it will give the summation for the numbers from D2 to D24. Now open the equal sign in cell D25 and type SUM. Look at the below example it has data for 23 cells. This is enough if the range of cells is selected, or else we need to keep mentioning the cells individually. If the range of cells is selected, it requires only one argument. SUM function requires many parameters it the each is selected independently. That is why we have an inbuilt function called SUM function to deal with it. It will be almost impossible to select one by one. I had only 4 cells to add in the above example, but what if there are 100 cells to add. The problem with this manual formula is that it will take a lot of time to apply in the case of many cells. So the result will be:įirstly I have selected the first number, cell A2 then I have mentioned the addition symbol +, then I have selected the second cell and again the + sign, and so on. I am going to apply the simple calculator method here. I want to do the summation of a number in cell A6. We can do the summation in two ways we need not apply the SUM function rather, we can apply the calculator technique here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |