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(number1, [number2], [number3], ...)
- 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
- 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.
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.
|1||Date||Item Code||Item Name||Qty||Unit Price||Amount|
|2||10/4/2019||Item001||Dell Laptop 1||2||1200||2400|
|3||10/4/2019||Item002||Dell Laptop 2||1||1240||1240|
|4||10/5/2019||Item003||Dell Laptop 3||3||1130||3390|
|5||10/5/2019||Item003||Dell Laptop 3||4||1130||4520|
|6||10/5/2019||Item002||Dell Laptop 2||5||1240||6200|
|7||10/6/2019||Item001||Dell Laptop 1||1||1120||1120|
|8||10/7/2019||Item001||Dell Laptop 1||7||1150||8050|
|9||10/9/2019||Item003||Dell Laptop 3||3||1100||3300|
|10||10/9/2019||Item002||Dell Laptop 2||8||1200||9600|
|11||10/10/2019||Item003||Dell Laptop 3||2||1000||2000|
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:
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:
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.