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

Sum syntax

=SUM(Value, ...)

Argument Argument description
1Value Either a number or a range/array of multiple numbers.
2Any 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.


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.


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.


Spreadsheet editor
Nicely done!

​Get Good at Excel on Autopilot

Sign up to our newsletter and receive ​Excel articles, tips and tricks delivered straight to your inbox. All you have to do is read them! ​Plus, to get you started, you'll receive a PDF with 200+ Excel shortcuts.