Excel SUM Function and Formula with Examples


How to Use the SUM Function and Formula in Excel

In this tutorial, you'll learn how to use the SUM function and formula in Excel. SUM is used to add individual values, values in a range of cells, or cell references of values.

SUM Syntax

=SUM(number1, [number2], [number3], ...)

Arguments

  • Number1: The first number that you want to sum
  • Number2: [optional]. The second value that you want to sum
  • Number3: [optional]. The third value that you want to sum

Remarks

  • Arguments can be numbers, ranges, arrays, constants, cell references, and the results of the other functions or formulas. You can specify up to 255 arguments.
  • SUM sums only the cell that value is number, and ignores any cell containing text value.

Excel SUM Function Examples

Example 1: Add a Group of Individual Values

You can use the SUM function to sum a group of individual values, as you can see in the following formula.

=SUM(1000,250,100)

Here there are three numbers 1000, 250, and 100. SUM sums all these three numbers and returns 1350.

Next, suppose you have the following sample sales records, and we're going to use it in the following examples.

 ABCDEF
1DateItem CodeItem NameQtyUnit PriceAmount
210/4/2019Item001Dell Laptop 1212002400
310/4/2019Item002Dell Laptop 2112401240
410/5/2019Item003Dell Laptop 3311303390
510/5/2019Item003Dell Laptop 3411304520
610/5/2019Item002Dell Laptop 2512406200
710/6/2019Item001Dell Laptop 1111201120
810/7/2019Item001Dell Laptop 1711508050
910/9/2019Item003Dell Laptop 3311003300
1010/9/2019Item002Dell Laptop 2812009600
1110/10/2019Item003Dell Laptop 3210002000

Example 2: Sum Values in a Range of Cells

Let's say you want to sum all the amounts in column F from cell F2 through F11. You can write the SUM formula as follows:

=SUM(F2:F11)

The result of the SUM formula above is 41820.

Example 3: Add Values in a Range of Cells and Another Cell Reference of Value

In this example, I show you how to add numbers in a range of cells and a cell reference of value.

Let's take a look at an example:

=SUM(F2,F7:F8)

Here, SUM sum all the amount of the item001 in column F, and returns 11570.

The Excel SUM function ignores any cell that contains text value. It sums only the cells containing value numbers.

Example 3: Add Values in Multiple Ranges of Cells

You can add values in multiple ranges of cells as you can see in the following example:

=SUM(F2:F3, F7:F8, F4:F6)

In this tutorial, you've learned how to use the Excel SUM function. SUM is one of the math functions in Excel. You can use it to add individual values, values in a range, or cell references of values. SUM ignores any cell containing text value. If you want to sum values with a specified condition, you can use the SUMIF function.

Leave a Reply

Your email address will not be published. Required fields are marked *