Using Formulas and Functions
- Understanding Formulas and Cell References in Excel
- Creating Simple Cell Formulas
- Assigning Names to Groups of Cells
- Using Names in Formulas
- Creating a Formula That References Values in an Excel Table
- Creating Formulas That Reference Cells in Other Workbooks
- Summing a Group of Cells Without Using a Formula
- Creating a Summary Formula
- Summing with Subtotals and Grand Totals
- Exploring the Excel Function Library
- Using the IF Function
- Checking Formula References
- Debugging Your Formulas
Creating a Summary Formula
After you enter data into a worksheet, you can create formulas to summarize the values and display the result of the calculation. You can summarize the values in a group of cells in many ways: You can find the total or average of the cell values, identify the maximum or minimum value in the group, or simply count the number of cells containing values. You can create these formulas by clicking the cell below or to the right of the cells you want to summarize, displaying either the Home tab or the Formulas tab, and clicking the AutoSum button. (The button appears on both tabs.) Clicking the AutoSum button itself creates a SUM formula, which finds the arithmetic sum of the values, but you can choose other calculations by clicking the AutoSum button’s down arrow. After you create the formula you want, you can use the result in other calculations.
Create an AutoSum Formula
Click the cell where you want the summary value to appear.
Click the Home tab.
Click the AutoSum down arrow.
Click the AutoSum function you want to use.
If necessary, select the cells with the data you want to summarize.