How can I sum the values in my range! (sum)
We can do this in excel with a single formula:
- SUM: Sum the number in my selected range
Syntax
=SUM(sum_these_values)
Example
Let’s use an example to illustrate the formula. We want to sum the values in our Numbers column (the black cells).
![](https://www.helpxel.com/wp-content/uploads/2021/10/SUM_goal.jpg)
The Steps
![](https://www.helpxel.com/wp-content/uploads/2021/10/SUM-Example-1024x512.jpg)
sum_these_values: the Numbers column
=SUM(Numbers column)
![](https://www.helpxel.com/wp-content/uploads/2021/10/SUM_range.jpg)
Result
formula
=SUM(B3:B7)
output
![](https://www.helpxel.com/wp-content/uploads/2021/10/SUM_result.jpg)
And there you have it, the total of our numbers column is 15!
Try out another Excel fundamental: if statement