|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:

IF YOU LIKE OUR EXCEL TUTORIALS PLEASE DON'T FORGET TO SHARE

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
       



Previous

Next



YOUR COMMENTS ARE MOST IMPORTANT TO US:

0 Comments



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.