Friday, 25 July 2014

How to use the SUM Function in Microsoft Excel 2010


The SUM function can be used to perform calculations on worksheet data. It takes all of the values in each of the specified cells and totals their values. The formula syntax for the SUM function is:
=SUM(number1,number2,......)

To use the SUM function, do the following on your worksheet:
1. Select the cell where you want your total value to be inserted.
2. On the [Formulas] tab, in the [Function Library] group, click [Insert Function].
The Insert Function dialog box will be displayed as shown below:



3. Having SUM function highlighted, click OK.
The Functions Arguments box will be displayed with the default range selected, click OK.
4. The total value will be automatically inserted in the cell you have selected.