​​​​Sum

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.

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.

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

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.

Nicely done!
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"36c04":{"name":"Main Accent","parent":-1},"3a8fd":{"name":"Accent Light","parent":"36c04","lock":{"saturation":1,"lightness":1}}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"36c04":{"val":"rgb(255, 204, 102)","hsl":{"h":40,"s":1,"l":0.7}},"3a8fd":{"val":"rgb(241, 241, 241)","hsl_parent_dependency":{"h":0,"s":0,"l":0.94}}},"gradients":[]},"original":{"colors":{"36c04":{"val":"rgb(255, 204, 102)","hsl":{"h":40,"s":1,"l":0.7}},"3a8fd":{"val":"rgb(241, 241, 241)","hsl_parent_dependency":{"h":0,"s":0,"l":0.94}}},"gradients":[]}}]}__CONFIG_colors_palette__

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

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"2dd0d":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"2dd0d":{"val":"rgb(45, 164, 92)","hsl":{"h":143,"s":0.57,"l":0.41}}},"gradients":[]},"original":{"colors":{"2dd0d":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Join List
>