Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

This chapter is from the book

Calculating Totals with AutoSum

A range of cells can easily be added using the AutoSum button on the Formulas tab. AutoSum suggests the range to sum, although this range can be changed if it’s incorrect. AutoSum looks at all of the data that is consecutively entered, and when it sees an empty cell, that is where the AutoSum stops. You can also use AutoSum to perform other calculations, such as AVERAGE, COUNT, MAX, and MIN. Subtotals can be calculated for data ranges using the Subtotals dialog box. This dialog box lets you select where the subtotals occur, as well as the function type.

Calculate Totals with AutoSum

  • yellow-01.jpg Click the cell where you want to display the calculation.

    • To sum with a range of numbers, select the range of cells you want.
    • To sum with only some of the numbers in a range, select the cells or range you want using the Ctrl key. Excel inserts the sum in the first empty cell below the selected range.
    • To sum both across and down a table of number, select the range of cells with an additional column to the right and a row at the bottom.
  • yellow-02.jpg Click the Formulas tab.
  • yellow-03.jpg Click the AutoSum button.

  • yellow-04.jpg Click the Enter button on the formula bar, or press Enter.

Calculate with Extended AutoSum

  • yellow-01.jpg Click the cell where you want to display the calculation.
  • yellow-02.jpg Click the Formulas tab.
  • yellow-03.jpg Click the AutoSum button arrow.
  • yellow-04.jpg Click the function you want to use, such as AVERAGE, COUNT, MAX, and MIN.
  • yellow-05.jpg Press Enter to accept the range selected.

Calculate Subtotals and Totals

  • yellow-01.jpg Click anywhere within the data to be subtotaled.
  • yellow-02.jpg Click the Data tab.
  • yellow-03.jpg Click the Subtotal button.
  • If a message box appears, read the message, and then click the appropriate button.
  • yellow-04.jpg Select the appropriate check boxes to specify how the data is subtotaled.
  • yellow-05.jpg Click OK.
  • + Share This
  • 🔖 Save To Your Account