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!




The syntax of the function is quite simple:


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.


Example 1 – Practice SUM Function Online

Now, let’s practice:

Easy, right? 🙂

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

Example 2 – Practice SUM Function Online

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

Having an issue with the formulas' language? check out this post