|Connect us with

Addition Formula in Excel | SUM in Excel

SUM in Excel | Sum Syntax | Sum Range | Sum Multiple Range | Sum Entire Column | Auto Sum in Excel

The SUM function is used to sum a range of cells in Excel. you can add multiple ranges, individual cell values, or cell references. the SUM function is a common way to add up cell values in Excel.

There are multiple ways to add the numbers in excel. we can sum cell numbers using the (+) plus sign. if we use (+) plus sign it will take more time to add one by one, but using SUM function it is easy to add the values from a range of cells. this tutorial gives you a detailed explanation of adding values(SUM) in Excel.

SUM Function Syntax:=SUM (number1, [number2], [number3], ...)

SUM Function Examples:

SUM function itself it says that summing (adding values) of values. In the below examples we can see multiple methods of Addition in Excel.

SUM Range:

In the below example, we did the total value of the range of cells in Excel using the SUM function.

SUM in Excel

SUM Function and (+) Sign:

Here column C Total and column D Total show the same result. in column C, the total contains the SUM function to get the result. and column D adds each cell value individually.

SUM function Example

SUM Multiple Ranges:

In this below example we have added multiple ranges using the SUM function.

Multiple Range Sum in Excel

SUM Entire Column:

To do the entire column sum, use the SUM function without any cell references. in this example, we used=SUM(A:A) to find the SUM of the entire column.

Sum Entire Column in Excel

AutoSum in Excel:

One easy way to add up values in Excel is AutoSum. for this, select a cell next to numbers you want to SUM then click Autosum. That's All, Excel will do the Addition for you. When you click on AutoSum, Excel automatically enters a formula to sum the numbers.

We have already discussed that Autosum is the easiest way to Sum a Column or Row numbers. and the shortcut key to use AutoSum is ALT +=. let's see the AutoSum Example in Excel.

AutoSum in Excel

In this above example, I have selected the cell below the column of numbers and I just used a shortcut key ALT+=to select Autosum. if you want to select it from Excel Ribbon, go to Home Tab and click on Auto-Sum. then it will automatically show the sum of the columns. in the same way, you can also use AutoSum rows.

You May Also Like the Following Excel Tutorials:


Subscribe for more videos on our Youtube channel. if you like our tutorial please Like and Subscribe to our Facebook and Youtube.

To Get FREE Excel Shortcut Keys





Why basictutorials.in ?

● To Learn Tutorials in a Simple Way.

● To Learn Excel Basics With Downloadable Samples.

● To Learn HTML With Sample Website Code.

● To Learn PowerPoint Presentations.

● To Learn MS Word for Offical use.