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.
Example 1 – Practice SUM Function Online
Now, let’s practice:
SUM is just the start.
Master every Excel function with Macquarie’s structured Excel Skills for Business on Coursera — 1M+ learners, certificate included. See the course on Coursera →
Master every Excel function with Macquarie’s structured Excel Skills for Business on Coursera — 1M+ learners, certificate included. See the course on Coursera →
Can't access the exercise? Below you can find the link to download the Excel file:
Sum-Practice-1.xlsx (14271 downloads )Easy, right?
Enter our Excel Exercises Page to learn and practice SUM and other common Excel formulas!