Summing a range of data
You can use the Total command to sum a range of numerical data. This command inserts the @SUM formula in the cell where you want the total to appear.
- Click the cell where you want the total to appear.
- In the action bar, click Total.
The @Function menu appears with @SUM highlighted.
- Click Insert.
The @SUM formula appears in the cell with the argument placeholder, list, highlighted.
- In place of list, type the name or address of the range you want to sum.
For example, to sum range A1..B5, type A1..B5 in place of list.
- Press ENTER.
The sum of the range appears in the cell.
See also
Entering a number
Editing data
Building your worksheet
Entering an @function