Insert a total for a range

Office Web Components

Insert a total for a range

You can insert a sum for a range of cells automatically by using AutoSum.

  1. In the design window, make sure the spreadsheet is activated. For instructions, see Help for your design program.
  2. Click the first blank cell that follows the data you want to sum, either below the column of data or to the right of the data in a row, or select a column range to sum.
  3. On the toolbar, click AutoSum Button image.

    A suggested formula is displayed in the cell you selected or in the cell below the column range you selected.

  4. Do one of the following:
    • To accept the suggested formula, press ENTER.

    • To change the suggested formula, select the range you want to sum and press ENTER.