Excel is a spreadsheet program, widely used by businesses and individuals. Its purpose is to create grids of numbers, texts, and formulas specifying calculations. One of the most commonly used functions in Excel is the SUM function.

In case you would like to learn how to use the SUM function in Excel properly, just continue reading.

What Is the SUM Function?

In simple words, the SUM function adds values. It is designed to return the sum of values you supplied, whether individual values, ranges, or cell references, or a mix of all three. The SUM function can handle up to 255 individual references.

Syntax of the SUM Function

Knowing the syntax of functions in Excel can help you understand how the function works. The Excel addition formula or the syntax is:

        =SUM (number1, [number2], [number3], ...)
    
  • number1 – is the first number that you want to add; required. This can be a number, a cell range (B2:B8), or a cell reference (B6).
  • number2 – is the second number you want to add; optional.

There are two basic ways to use the SUM function. In the first example seen below, the function will add the values in cells from A2 to A10.

        =SUM(A2:A10)
    

In the second example seen below, the function will add values in cells from A2 to A10 and the cells B2 to B10.

        =SUM(A2:A10, B2:B10)
    

Where to Write Functions?

  1. You can write an Excel function by selecting the cell (where you want the results to be) with your cursor and simply typing out the formula there.
  2. Or, you can select the cell (where you want the results to be) with your cursor and type the function in the Insert Function field, instead.
Where to write functions

Adding Numbers in Excel With the SUM Function

Functions are pre-built formulas in Excel, which make things simpler. With that said, you are always welcome to use the elementary way to sum values in Excel.

Instead of typing out numbers or cell references and using the + sign or commas, you can simply type the SUM syntax. These are the two basic approaches on how to add in Excel:

  1. You can choose to list cell references of numbers that you want to add with the SUM function. However, this means that you will have to list all the cell references you want to add.
Add formula in Excel
  1. The second approach is more helpful when you have a lot more that you want to calculate. It is one of the easiest ways to see just how powerful this function actually is.
SUM Function Excel

With that said, you should know that the SUM function does not limit you to a single column or row. When you are dealing with hundreds of rows and columns that need to be calculated, the SUM function really comes in handy.

SUM function across columns

You could also just select all the numbers that you want to calculate, and their sum will be listed below. If you right-click on the area on the bottom, you can choose the results you want to get after selecting the columns and rows.

Seeing the sum of selected numbers

Another great thing is that the SUM function will change accordingly. This means that if you have deleted some rows or columns included in the SUM function, it will update the results.

If you still have difficulties understanding the SUM function, Microsoft has provided a couple of useful examples you can check out.

Related: How to Use the SUMIF Function in Excel

The SUM Function Will Make Your Life Easier!

There are many benefits to using the SUM function, especially if you are working with a lot of numbers. Instead of having to type out every single number to calculate it, you can use the SUM function, which will upgrade as you change the data.