**Returns the sum of the values given as its argument(s).**

## Sum syntax

**=SUM(**`Value`

**,** `...`

**)**

Argument | Argument description | |
---|---|---|

1 | Value | Either a number or a range/array of multiple numbers. |

2 | … | Any number of more numbers or ranges/arrays of multiple numbers. Up to 255 can be given. |

### Try it for yourself

Use the SUM function in cell **B7 **to calculate the monthly income after expenses.

Note that you can click the *Show Answer* button to look at the answer if you cannot figure it out.

## Explanation

The sum function sums the values given. If you use the range [B2:B5] as argument it will sum the values given in that range.

Another solution would be to use `=SUM(B2, B3, B4, B5)`

or even `=SUM(B2:B4, B5)`

. Really any combination of numbers and/or ranges works.

## Questions

**What happens with a sum over empty cells, text or errors?**

The sum function will simply ignore empty cells or text. Summing over errors will return an error.

## Examples

#### Using different types of arguments

Find out how many days off you have taken this year by using a SUM function in cell **E4** that uses a range (e.g.: A1:A2) and a single number as arguments.