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.

  1. Click the cell where you want the total to appear.

  2. In the action bar, click Total.

    The @Function menu appears with @SUM highlighted.

  3. Click Insert.

    The @SUM formula appears in the cell with the argument placeholder, list, highlighted.

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

  5. Press ENTER.

    The sum of the range appears in the cell.



See also
Entering a number
Editing data
Building your worksheet
Entering an @function