# Excel SUM Function and Formula with Examples

## Learn How to Use the SUM Function in Excel

In this tutorial, you'll learn how to use the Excel SUM function

SUM is a function to add individual values, values in a range of cells, or cell references of values.

### SUM() Syntax

The syntax of the SUM() function is as follows:

=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 cells containing text value.

### SUM() Function Examples

#### Example 1: Adding a group of individual values

The following formula shows how to add individual values:

=SUM(1000,250,100)

SUM() sums 1000, 250, and 100, and returns 1350.

Let's see more examples below.

Suppose you have the demo data, as shown below:

#### Example 2: Adding values in a range of cells

Let's say you want to sum all the amounts in column F starting from cell F2 through F11.
The formula is as follows:

=SUM(F2:F11)

The formula returns 41820.

#### Example 3: Adding values in a range of cells and another cell reference of Value

You can add numbers in a range of cells and a cell reference of value, as the following example shows:

=SUM(F2,F7:F8)

The formula sums all the amount of the item001 in column F and returns 11570.

SUM()ignores any cells that contain text value. It sums only the cells containing value numbers.

#### Example 3: Adding values in multiple ranges of cells

You can add values in multiple ranges of cells, as the following example shows:

=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. You can use it to add individual values, values in a range, or cell references of values.

SUM ignores any cells containing text value.

If you need to sum values with a specified condition, use SUMIF.