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).

The Steps

sum_these_values: the Numbers column
=SUM(Numbers column)

Result
formula
=SUM(B3:B7)
output

And there you have it, the total of our numbers column is 15!
Try out another Excel fundamental: if statement