How to Build Excel 2007 Formulas with the Insert Function Dialog Box
Determining Cell Data Types with Excel 2007's TYPE Function
Inserting Subtotals in an Excel 2007 Worksheet

Using AutoSum for Quick Calculations in Excel 2007

To quickly sum a row or a column of values in an Excel 2007 worksheet, you can use the AutoSum button (the one with the on it) in the Editing group of the Home tab of the Ribbon. When you click this button, Excel inserts the built-in SUM function into the active cell and simultaneously selects what the program thinks is the most likely range of numbers that you want summed.


Click a cell below (or to the right of) the values you want to sum.

This tells Excel which values you want to sum.


Click the AutoSum button in the Editing group on the Home tab.

Excel inserts an equal sign followed by the SUM function and a suggested range of values to sum displayed in a marquee.


If the suggested range is incorrect, drag the cell cursor across the cells to select the correct range.

The marquee adjusts to surround the range of cells you select.


Press Enter or click the Enter button on the Formula bar.

Excel enters the SUM formula in the cell.

Although the AutoSum button’s primary function is to build formulas with the SUM function that totals ranges of numbers, that’s not its only purpose. You can have the AutoSum feature build formulas that compute the average value, count the number of values, or return the highest or lowest value in a range — all you have to do is click the drop-down button that’s attached to the AutoSum command button on the Home tab and then click Average, Count Numbers, Max, or Min on its drop-down menu.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Tracing Precedents and Dependents in Excel 2007 Formulas
Switching Vertical and Horizontal Data with Excel 2007's TRANSPOSE Function
Using Logical Excel Functions in Excel 2007 Formulas
Assigning Names to Constant Values in Excel 2007
Calculating Loan Payments with Excel 2007's PMT Function