SUM Function – Explanation

Sum is a function that allows us to sum numbers easily.
We can type in the function actual numbers, but we can also use cell references and sum entire ranges!

Example

 

Syntax

The syntax of the function is quite simple:

=SUM(value1,value2,value3…)

value1 – number or cell reference we’d like to sum.  If we use cell reference (for example – the range of cells between B2 to B6), we can select a range and sum it – for example, B2:B6.

 

Practice SUM Function Online – Exercise 1

Now, let’s practice:

Easy, right? 🙂

Let’s do another exercise and practice using SUM horizontally:

Practice SUM Function Online – Exercise 2

Enter our Excel Exercises Page to learn and practice SUM  and other common Excel formulas!