## Excel SUM function

The SUM function in excel allows you to add values, the function returns the sum in the cell it is entered in. The SUM function is cleverly designed to ignore text and boolean values, adding only numbers.

#### Syntax

SUM(*number1*, *number2*, ...)

#### Arguments

The SUM function lets you add values in cell ranges, arrays, constants. You can have up to 255 different arguments.

#### Table of Contents

- Add values in a cell range
- Add values in an array
- Multiple cell ranges
- Numbers and text
- Boolean values
- Expanding cell reference
- SUM with a condition
- SUM with multiple conditions
- SUM - VBA example
- Download excel *.xlsm file
- SUM formula examples

### Add values in a cell range

The SUM function lets you add values in a cell range, like this = SUM(B3:B7), instead of adding values in a formula using the plus sign, like this =B3+B4+B5+B6+B7.