Calculating Totals with AutoSum

A range of cells can be easily added using the AutoSum button on the Standard toolbar. 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. Subtotals can be calculated for data ranges using the Tools menu and the Subtotals dialog box. This dialog box lets you select where the subtotals occur, as well as the function type.

Calculate Totals with AutoSum

Click the cell where you want to display the calculation.

Click the AutoSum button on the Standard toolbar.

Click the Enter button on the formula bar, or press Enter.

Calculate with Extended AutoSum

Click the cell where you want to display the calculation.

Click the AutoSum list arrow on the Standard toolbar.

Click the function you want to use.

Press Enter to accept the range selected.

Calculate Subtotals and Totals

Click anywhere within the data to be subtotaled.

Click the Data menu, and then click Subtotals.

If a message box appears, read the message, and then click the appropriate button.

Click to select the appropriate check boxes to specify how the data is subtotaled.

Click OK.

Did You Know?

You can select additional AutoFill commands . Click the Edit menu, and then click Fill to select additional commands such as Up, Down, Left, Right, Series, or Justify.