In yesterday’s post, we saw how to enter the SUM function using the AutoSum button. But there are also several other functions available using the AutoSum feature. These are:
- SUM Totals the values in a selected range
- AVERAGE Computes the average of the values in a selected range
- MIN Returns the lowest value in a selected range
- MAX Returns the highest value in a selected range
- COUNT NUMBERS Totals the number of cells with values in a selected range
To Enter Additional Functions using AutoSum
- Select the cell or range of cells where you want the formula to be inserted.
- Click the arrow to the right of the AutoSum button on the Ribbon.
- Chose the desired function.
- If the cell range that Excel chooses is not the desired range, drag over the range to be included in the formula.
- Press the Enter key to verify the formula.
Similar Posts:
- Using the AutoSum Button in Excel
- Entering in Functions Manually in Excel
- Using the Insert Function button in Excel
- Using 3-D Formulas and References in Excel
- Understanding Date/Time Functions in Excel
- Using AutoCalculate in Excel 2007
- Counting Cells with Values in Excel
