In this tutorial, we will explore more about the sum function of excel which we provide examples and explanations on how it works.
What is the sum function in Excel?
The sum function formula of excel is used to add the numerical values in a range of cells. The value that can be supplied in functions either in cells, references, or range of cells. So this function is used in a situation when it is required to total selected cells.
In addition, this function SUM can handle up to 255 individual arguments.
The Syntax of the SUM Excel Function
The syntax of the sum is shown below:
=SUM(number1, [number2], [number], …)
This function accepts the arguments as follows:
- number1 – The first value to sum.
- number2 – [optional] The second value to sum.
- number3 – [optional] The third value to sum.
How to Use Sum Function in Excel
Time needed: 5 minutes.
Primarily, to use the sum function you just need to type (=SUM) followed by the arguments. However, we provide you here the alternative steps on how to use the sum function of excel.
- In the Formulas tab, click the “math & trig” option, as shown in the following image.
- From the drop-down menu that opens, select the SUM option.
- In the “function arguments” dialog box, enter the arguments of the SUM function. Click “Ok” to get the output.
- Here’s the output.
Excel SUM Formula Examples
Here we will give a few examples to understand how to use it in different ways, thus we will provide figures to answer clarification.
In this example, we will use Autosum button which is the quickest and easiest way to sum up a range of cells. Once it is used Excel sum function automatically enters on selected cells. As defined above it totals one or more numbers in a range of cells.
The first example, below, shows how to use the AutoSum feature.
|1. First, select a blank cell you want sum below the cells of the row.|
|2. On the Home Tab Click the Autosum button or Alt+= on your keyboard.|
|3. Then in your active cell A SUM formula will appear, with a reference to the cells above. In our figure, the formula in C5 is (=SUM(C2:C4).|
Note: You can extend the frame if your cells are not included.
|4. Click Enter Key then the result will display.|
Normally, the SUM function is often used in bigger and more complex calculations. So let’s assume here the given data.
The illustration above shows a piece of missing information in a worksheet; now let’s use the sum function with IF function to display a warning message.
Here is the formula we used.
We get the result below:
Excel SUMIF Formula
The SUMIF function of excel calculates the sum value of the range of cells with true or false conditions.
The syntax of this function is SUMIF(range, criteria, [sum_range]).
SUMIF Two Required Arguments
- range – cells to check for the criteria
- criteria – value to use as criteria
SUMIF Optional Arguments
- [sum_range] – cells to sum if omitted, values in range are summed
- These arguments can be cell references or can be typed into the formula.
Example Excel SUMIF Formula
In this example, we will know how to calculate using SUMIF and meet a specific criterion or multiple criteria. Consider the following given data in Excel table to calculate each income.
- Select the cell in which you want to see the total
- Input an equal sign (=) to start the formula
- Type: SUMIF(
- Select the cells that contain the values to check for the criterion.
- Type a comma, to separate the arguments
- Select or type the criterion.
- Type a comma, to separate the arguments
- Select the cells that contain the values to sum.
- The completed formula is:
- Press the Enter key to complete the entry
Note: Instead of typing the criterion in a formula, you can refer to a cell. For example, the formula in step 9 above could be changed to: =SUMIF(A2:A10, C3, B2:B10)
Excel Sum Formula Shortcut
Suppose we have values in more than one column, so how can we add this numerical value?
- First, you must select all the columns you want to add.
- Then, Press “Alt+=”.
Now it has already applied the formula to the last cell selected. Note do not press the ENTER KEY instead pressing CTRL+ENTER to apply the formula on the same selected cell.
Hence the result is presented below after using the shortcut keys.
Horizontal Auto Sum in Excel
This time we also have a horizontal Autosum shortcut way. As we’ve seen how to apply it is a vertical set of data it is more likely the same as how it is done.
- First, Select the cell you want to be total, for instance B2 to C10.
- Then Press the excel Sum shortcut, Alt+=.
As we can see, it has applied the Excel SUM formula shortcut to the beside cell of the selected cells.
In summary SumFunction of Microsoft excel helps the summation easier; it also considers adding a numerical set of data with a condition considering the possibility when doing tasks or financial reports specifically.
Thank you for reading!