SUM - to sum/calculate a total of numbers. Example of formula would be =SUM(Range X:Range Y)
Example 1
Select row or column to calculate the total of values. In this example, the row of values would be A2 to A7.
To calculate the total values, type =SUM(Range X:Range Y) in the destination cell to display. In this example, it would be =SUM(A2:A7). Hit Enter to display the calculation result.
Example 2
We can also use SUM to calculate the total of multiple rows or column. For example, this row A and row B.
We're going to calculate values in column A and column B.
In selected cell for display value, type =SUM(A2:B7). Hit Enter to calculate the result.
