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

: 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 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. S**UM **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.

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