SUM Function in Ms Excel 2013

How to add numbers using SUM function in MS Excel 2013?

Explanation

Sum function is used to add the set of values. To sum values in excel file follow the steps given below.
Step 1: Select the cell in which you need to display the answer.
Step 2: You can sum the values using two options.
Option 1: Type "=Sum". Inside the parenthesis, select the cell reference and separate them using comma symbol. Press Enter key to obtain the result.
For example, to sum the values in the cell reference A1, A4 and A6 enter as
=Sum(A1,A4,A6) and hit enter.

Sum of the values is obtained in the selected cell where the sum function is performed.

Option 2: Type "=" symbol. Type the cell reference and separate them using the plus ( ) symbol. For example, to sum the values in A1, A3 and A5, type as =A1+A3+A5 and hit enter.

Below image shows the result for the sum function performed above.

To sum range of values:
Step 1: Type "=Sum". Open parenthesis and select the range of values by clicking the first cell and drag it till the extend you need. Then hit enter.

For example, to sum the range of values from A1 to A8, enter as =Sum(A1:A8) and hit enter.

Related Topics