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.

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.

Share on Facebook Share on Twitter Share on Google Plus

About Dhakkanz

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.