In this post, we will learn how to use the sum formula of excel, and what does the sum formula return to us? In this post, you have been told 3 ways to using which you can calculate total or sum in MS Excel.
As the word Sum itself means to add means to add more than one number. In exactly the same way, Sum Formula is also used in Excel to add two or more numbers.
We use the formula of Sum when we have to add numeric type data.
Note: To apply any formula in MS EXCEL, we have to start with Equals = sign only and it is mandatory.
Syntax : =Sum(Number 1, Number 2, . . . . )
1 Sum Using Number:
If you want to calculate the total using direct numbers, then for that you click with your mouse in the formula bar and write your numbers like this (4,5,6). You have to put a work (,) after typing each of your numbers. As shown in the image below.
2 Sum Using Cell Reference:
3 Sum Using Cell Range: =sum(A1:A10)
#2Method AUTOSUM In Excel ALT + =
In this method, we will learn how to find the sum or total using the shortcut key, the keyboard is even easier, you just have to press the ALT + = key together from your keyboard, and as soon as you press it, The formula of sum will be automatically applied in that cell which will be kept active. As can be seen in the image below.