Returns the sum of the values given as its argument(s).
|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.
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.
The sum function will simply ignore empty cells or text. Summing over errors will return an error.
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.