How to Use AutoSum's Other Functions in Excel

The AutoSum function can readily sum-up a column or row of numbers, making those financial reports easy to prepare. The AutoSum feature can perform four more functions besides addition.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Microsoft Excel 2002 or later

1. 
    
   Average

   AVERAGE. To use the AutoSum button to figure an average, first click in the cell beside or below the row or column of numbers to average. That is the insertion point. In our example, the insertion point is at E9.
   
   Click the down arrow of the AutoSum button and then click on Average. When you press enter, the average of that column will appear. In our example, the average number of apples for the week is 1.2.

2. 
    
   Count

   COUNT. After you have set your insertion point, click the down arrow of the AutoSum button, and then click on Count. When you press Enter, Excel shows a result that tells how many of the cells had data in them. If one of our cells had been empty, the result would have been four versus five.

3. 
    
   Max

   MAX. Insertion point placed, click on the AutoSum down arrow and then click on Max. After pressing Enter, the result will show the greatest or maximum number in the selected data.

4. 
    
   Min

   MIN. Similar to the MAX function, after setting your insertion point and then clicking the down arrow of the AutoSum button followed by a click on Min, with a press of the Enter key, the result in the cell will be the lowest or minimum number in the cell.

Resources

• How to Use AutoSum in Microsoft Excel

[AutumnLeavz]

on 4/29/2008 Thanks so much! This is definitely getting bookmarked! 5 stars!