Function Sum()

Sum ()

This function is used to find the sum or total of values in a range.


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.

L
et 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.

Share on Google Plus

About Rishie Khurana

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Friday, May 22, 2009

Function Sum()

Sum ()

This function is used to find the sum or total of values in a range.


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.

L
et 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.

Function Sum()SocialTwist Tell-a-Friend

0 comments:

Post a Comment