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.
