## 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 17

## What is the purpose of **SUM** function?

**SUM**

It **Adds all the numbers** in a range of cells.

## What is the Return value of **SUM** function?

**SUM**

It returns a number.

## How many arguments does **SUM** function have?

**SUM**

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?

**SUM**

This function is available for all excel **versions **(2003-2019)

## Errors in **SUM** function

**SUM**

## SUM** related functions :**

- SUMIF function
- SUMIFS function
- SUMPRODUCT function
- DSUM function