What is SUM Function in Excel?
The SUM function is one of the math functions of Excel.
It Adds all the numbers in a range of cells.
We can find this function in Math & trig category of insert function Tab.
How to use SUM function in excel
- Click on an empty cell (like F5 )
2. Click on fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select math and trig category
5. Select SUM function
6. Then select ok
7. In the function arguments section you will see SUM function
8. In the number1 box you must enter a number (for example 5)
9. In the number2 box you must enter a number (for example 10)
10. You will see result= 15
11. If you enter (+5,10) result will be 15
12. If you enter (-5,10) result will be 5
13. If you enter (-5,+5) result will be 0
14. You will see results in the formula result section
Examples of SUM function in Excel
Example 1:
How to use SUM function in excel
You can see examples of SUM function below:
sum(A2:C2) ----->>>>answer is 14.9
sum(A3:C3) ----->>>>answer is 0
sum(A4:C4) ----->>>>answer is 2
sum(A5:C5) ----->>>>answer is 11
sum(A6:C6) ----->>>>answer is 17What is the purpose of SUM function?
It Adds all the numbers in a range of cells.
What is the Return value of SUM function?
It returns a number.
How many arguments does SUM function have?
This function has just 255 Argument.
The argument of SUM function is number.
In the number1 TO 255 box you must enter a number.
The argument of SUM function is required and not optional.
SUM(number) = number
Which version of excel supports SUM function?
This function is available for all excel versions (2003-2019)
Errors in SUM function
SUM related functions :
- SUMIF function
- SUMIFS function
- SUMPRODUCT function
- DSUM function
