# SUM Function The Excel SUM function is a MATH & TRIGONOMETRY function that can return the sum of values supplied into it. These values can be numbers, cell references, ranges, arrays or combination of all these.

SUM function in Excel can handle up to 255 individual arguments.

### Function Type

Math and Trigonometry

### Return value

Sum of numbers supplied into the function

### Syntax

`=SUM(number1,[number2], ...) `

### Arguments

number1 – The first value to sum.

number2 – [optional] The second value to sum.

### Examples

#### Sum of Direct values

In this example, the SUM function is used to find out the sum of 3 direct values 10, 20 and & 30

`=SUM(10,20,30)`

#### Sum of values in individual cells

The following formula will return the sum of values in the cells B2, B3, and B4

`=SUM(B2,B3,B4)`

#### Sum of values in a data range

The following formula will return the sum of values in the data range E2:E4

`=SUM(E2:E4)`

#### Sum of values in a two-dimensional data range

Formula to find the sum of values in the data range B2:F11

`=SUM(B2:F11)`

#### Combination of direct value, 2 cells references and a data range inside SUM function

The following formula will return the sum of values in the range B4:C7, cells C2 & B10 and the number 10

`=SUM(B4:C7,C2,B10,10)`