Insert a total for a range

Microsoft Office Web Components

Insert a total for a range

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

  1. 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.
  2. On the spreadsheet 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.

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