Most valuable professional
  • Excel Book Excerpt

Excel Use AutoSum to Quickly Enter a Total Formula

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Use AutoSum to Quickly
Enter a Total Formula

Problem: I have numeric data in Excel. I need to total the rows quickly.

LE10000232.jpg 

Figure 260 Add total formulas.

Strategy: You can use the AutoSum button on the Home tab or Formulas tab. The AutoSum button is a Greek letter sigma.

LE10000233.jpg 

Figure 261 A Greek letter sigma is the math symbol for sum.

Here’s how you use AutoSum to add a total formula:

1. Place the cell pointer in cell B10. Click the AutoSum button. Excel analyzes your data and predicts that you want to total the range of numbers above the cell pointer. Excel proposes the provisional formula =SUM(B2:B9).

2. Review the range in the proposed formula, if needed. If the range is correct, press Enter to accept the formula. Excel displays the total.

LE10000234.jpg 

Figure 262 Excel proposes a formula.

3. With the mouse, drag the fill handle (the square dot in the lower-right corner of the cell pointer) to the right to include cells C10 through F10 and then release the mouse button. The formula will be copied to all five columns.

Additional Details: You can use Alt+= instead of clicking the AutoSum button.

Gotcha: Blank cells in the sum range will cause AutoSum to exclude cells above the blank cell.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: