## 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**

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

### 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**

**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:

A | B | C | D | E | F | |
---|---|---|---|---|---|---|

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: ****Adding values in a range of cells**

**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**

**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**.