Lets we see basic Sum Function

The sum is to add values. You can add two values and more than two values. As per the syntax you use.

**=SUM (A1: A10)**

**=SUM (number1: number N) Where N can be 2 to 255**

SUM Function =SUM(A1: A10) |

This syntax will count the sum of the values contains in cell no A1 to A10. It counts only numerical values if you write a non-numerical then the system will count non-numerical as 0. It can sum up to the 1

^{st}cell to 255^{th}cell.**=SUM (A1:A5,C6:C10)**

**=SUM (number N: number N, number N: number N)**

**Where N can be 1 to 255**

This syntax will count the values of your selected cells. It is the flexible formula.

You just have to select first range and place comma and select the second range. That will give you the sum of both the selected ranges of your sheet.

###
**SUM at Status bar**

If you select the data than status bar shows you

*SUM, AVERAGE and COUNTS*of your data. It is one of the quickest ways to see SUM.
By using right click on the status bar will show other option. What you want the quick result of. Available options of status bar are

*SUM, AVERAGE, COUNT, NUMERICAL COUNT, MINIMUM, and MAXIMUM*.###
**Flexible addition Using SUM**

The flexible sum is used when you want to add different ranges of cells and neglect the specific or avoid the cells which you do no\t want to count in your sum.

Sum Function Flexibility |

Different ranges of the formula will highlight with different colors. It can calculate Row range with column range also.

###
**Error Faced in SUM Function**

1. The sum value shows

It means the return value is longer than the cell width. It is solved by expanding cell width

**####**in place of the resultIt means the return value is longer than the cell width. It is solved by expanding cell width

2. In the result cell

if the values in the cell are formatted as text than this type of error comes. if you convert values to number from text this error will omit.

**shows function**but not the result valueif the values in the cell are formatted as text than this type of error comes. if you convert values to number from text this error will omit.

**3. Only numerical values are counted**in sum. If non-numerical values are placed in the sum range system will count it as a 0.

**4. #NAME**

This is a syntax error. If you have placed or by mistake an extra character existed in formula than this type of error occur.

**For Ex =SUM(A1:\A10)**

## No comments:

## Post a Comment