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!