Excel SUM Function

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

  1. Click on an empty cell (like F5 )
an empty cell in excel

2. Click on fx icon (or press shift+F3)

 fx icon in excel

3. In the insert function tab you will see all functions

insert function tab in excel

4. Select math and trig category

5. Select SUM function

6. Then select ok

excel SUM function

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

How to use SUM function in excel

11. If you enter (+5,10) result will be  15

use SUM function in excel

12. If you enter (-5,10) result will be  5

Examples SUM function in Excel

13. If you enter (-5,+5) result will be  0

 SUM function Examples in Excel

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:

Examples of SUM function in Excel
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  17

What 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 :

Leave a Reply

Your email address will not be published. Required fields are marked *