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. |
Spreadsheet editor
Well done! You successfully used the SUM function.
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
Spreadsheet editor
Nicely done!