how to sum multiple rows in excel (Easy Tricks) 2022

Friends, today's topic is going to be how to sum multiple rows in excel. if you also consider this a problem and it is a big problem for you, then it is not such a thing, it is very easy, you can sum any row and column, you can add without any difficulty. 

how to sum multiple in excel

Just you don't know the right way how to add rows in excel  I will try to tell you in simple words so that you can easily understand and take benefit from it.

I will try to tell you step by step If possible, I will try to tell you the formula and monal in both ways so that maximum benefit will be proved for you. 

how to sum multiple columns in excel

Friends first let's talk about how to sum multiple columns in excel very easily I will tell you to step by step You just remembered some instructions, which you have to follow.

• First of all, you have to turn on your computer, after turning on you have to search and open MS Excel in the search box on your computer. 
• If you have already prepared a table, then you add it, I will explain it to you through an example. You will have an interface in front of which will be made up of four to five categories at the top Home Insert Page Layout Formula Data Review View.
• I have prepared a table which I have to sum up now what will I do that I will go to the formula option from the above options.
• Now I am going to do the total sum of this number which I have to select Just hold right-click and select the number range in a column which you want to total or sum. 
• After selecting the range, you have to go upwards, where auto sum will be written, there will be a mark of sigma, you have to press there. Your numbers will be totaled as you press.

how to sum multiple rows in excel

Now let's talk about how you can sum multiple numbers in excel, it is also very easy, the same way as a column.

Similarly, you can also sum the number in rows, by selecting the range of them, by arrow you can press on the option of autosome (sigma) your numbers will be totaled. 

how to add in excel formula

In this way, I will tell you how you can sum numbers in rows and columns by formula (sum function).

Formula Apply in columns

Now I will tell you how to apply the formula with functions in columns, when you have to go to the column in the table where you want to total you have to write this(=sum(num1:num 2)). 

Now to total the column num for example my column d1to d7 I have to total. You have to write this formula in the box at the bottom where you want to do the sum. 

how to add rows in excel with formula

Now, exactly the same method will be applicable for adding the number in rows also. 

Now if you want to sum the number given in the rows, you have to use the same method, you have to apply by writing this formula at the place where you want to total.

Conclusion: In this article, I have tried to tell you the advanced sum function in excel by formula and manual method.

I have told you in a very simple way So friends if you liked this information and you have benefited from it, then you must share it with your friends and relatives. 

And if you have any questions related to this topic then you can be asked me in the comment box below, I will definitely reply to you.