In this article, you will find out how the SUM function is used as well as the many ways it can be practically applied in Excel. Additionally, you will see how to add the function to Excel using four different methods.
The SUM Function Syntax
The syntax for the SUM function is shown here: =SUM(number1,[number2],[number3],[number4]…) The SUM function is very straightforward. Numbers and cell references can be used to get a sum of multiple numbers. A range is usually used as a reference to collect data for this function. The function needs to be inputted like a formula to work properly. To manually add this formula to a cell, the following steps need to be followed:
The Sum of a Range of Data
You would sum a range like in the illustration below when all of the data that needs to be added together can be found in the same area of your spreadsheet. Data can be selected vertically or horizontally with multiple rows and columns. An example of this technique can be seen in the illustration below.
Sum With Cell References
You may opt to sum using cell references. This will allow you to sum from a vast number of cells from different areas of a workbook. Created by Joshua Crowder Each reference needs to be added to the formula and separated by a comma. This technique can be seen as being used in the illustration below.
Sum Using Numbers
You can also sum with just numbers alone without using any ranges or references. This might be useful when a set of numbers always stays the same, and you want to add a cell reference as a variable to the set of numbers. Created by Joshua Crowder An example of using numbers only in the SUM function can be seen in the illustration below.
SUM Using Named Ranges
Lastly, you may also sum named ranges of numbers as shown in the illustration below. Named range1 outlined in blue is being added to range2 outlined in red. Created by Joshua Crowder It’s worth noting that each of the 4 examples described can be used together interchangeably. Ranges can be used and followed by cell references, numbers, and named ranges as long as the correct syntax is used. Created by Joshua Crowder
Inserting the SUM Function
The SUM function can be inserted into a cell using two methods. In one method, you search for the function from the function library, and the other involves the use of an insert function button. Each can be completed in a few steps and is described in the following sections.
Inserting the SUM Funciton
To use this method, a cell is first selected. Next, the formulas tab is selected, and the “Math and Trig” button is be chosen from the function library. Next, SUM can be chosen from the dropdown menu. These steps are shown here in bold and in the illustration below. Formulas → Math & Trig → SUM After the functional arguments window appears, you have the option to add as many as 255 numbers, cell references, or ranges that contain 255 cells. Created by Joshua Crowder Each time you enter a number or reference into a field, a new one will appear for the next data entry. Once you have added the numbers and/or references that you need, click on the OK button. The functional arguments window can be seen in the example illustration below.
Inserting From the Insert Function Button
Another way to insert this function would be to insert it from the insert function button. This button is also found under the formulas tab and located on the upper left side of the Excel ribbon in the function library. Created by Joshua Crowder Formula Tab → Insert Function
Inserting the SUM Function
After clicking on the insert function button, the insert function window appears. Text can be entered to search for the function that you are looking for. After clicking OK, you will be directed to the functional arguments window.
Using the SUM Function Shortcut
There is an easy way to bring up the SUM function when you need it. Instead of typing out the formula or inserting the function, you can use a three-stroke shortcut. By holding alt + = you can get the function to appear after you have clicked in a cell. The option will not help you fill the formula like the last two insert options, but it will save you some keystrokes when entering the function manually. Created by Joshua Crowder This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional. © 2021 Joshua Crowder
