**or total of values in a range.**

*sum*

__Syntax__**:**

**= Sum (Number1, Number2, Range1,.....)**

*Number1, Number2, Range1 = Numbers/Ranges for which the total is to be calculated*

**Example:**

The function in the above image calculates the total (also called sum) for the range - C2:C6. The result of the function comes out to be 15,260.**Tip: **Sum() function proves to be much secure and robust than using ‘+’ symbol for addition as this function can bypass any errors (such as #NA, #Value) in the arguments entered.

*Let us look at the following example:*

In the below image, I have used ‘+’ sign to add up the 5 cells (C2, C3, C4, C5 and C6). The cell C4 contains an error and this causes the addition of the 5 cells to give an error. Also, if any of the cells in the given range contains a text, the result will again be an error.

Now, if you look at the image below, in which I have used Sum() on the same data and same range, the result of the addition does not give any error.

## 0 comments:

## Post a Comment