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 itself it says that summing (adding values) of values. In the below examples we can see multiple methods of Addition in Excel.
In the below example, we did the total value of the range of cells in Excel using the SUM function.
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 Multiple Ranges:
In this below example we have added multiple ranges using the SUM function.
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.
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.
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.
● 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.