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

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