Sum Function in Excel – Download 2 Practice Sheets

“SUM” Function in Excel: –

The Excel SUM formula is used when we need to sum the numerical values in the selected range, cell reference, or table column/row. It can sum together the numerical values in multiple selected ranges or cell references.

The features of the “SUM” function: –

• With the help of the SUM function, we can get the total of the numerical values in the selected array, range, or cells.
• It can be used further with other Excel functions.
• Error values or text values that cannot be recognized as numbers are not summed by this function.
• The logical values TRUE and FALSE are also not summed.
• Empty cells and text are also not summed.

Explanation of Function:

Now, we will explain the arguments of the function.

=SUM(number1, [number2], [number3], …)

number1: Number 1 is represented as the first selected cell, which we want to sum up.

[number2]: Number 2 is represented by the next selected cell that we want to sum up.

[number3]: Number 3 is represented by the next selected cell, which we want to sum up, and a process of selection is going on.

We can also select a range instead of selecting a number individually.  

=SUM(range1, [range2], [range3], …)

range1: Range 1 is represented as the first selected cells, which we want to sum up.

[range2]: Range 2 is represented by the next selected cells, which we want to sum up.

[range3]: Range 3 is represented by the next selected cells, which we want to sum up, and a process of selection is going on.

Example of Function: – 

I will show you how to apply this function.

From the following table, get the total amount.

Solution:-

We will apply the SUM formula and get the result. This is shown in the following steps: –

Step No. 1:

We will write the “=SUM(“ in the column of the result.

Step No. 2

Now select the range of cells on which you want to apply the function.

Step No. 3: –

Now, press Enter and get the result:

Thanks 

Please share and comment with your feedback.

To buy Microsoft Excel, Click Here.

Also, check out the following functions of Excel:

• How to use VLOOKUP in Excel – free explanation
• How to use HLOOKUP in Excel – free explanation 
• IF Function in Excel – Free Explanation with Example
• Excel SUMIF Function – Download Practice Sheet
• Excel MATCH Function—Download Practice Sheet
• Excel INDEX Function – Download Practice Sheet