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
