Microsoft Office Tutorials and References
In Depth Information
Creating a summary formula
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 that 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
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
that you want, you can use the result in other calculations.
Create an AutoSum formula
1 Click the cell where you want the summary value to appear.
2 Click the Home tab.
3 Click the AutoSum down arrow.
4 Click the AutoSum function that you want to use.
5 If necessary, select the cells with the data that you want to
summarize.
6 Press Enter.
3
4
5
1
SEE ALSo For information about finding a running total for a
group of cells without creating a formula, see “Summing a
group of cells without using a formula” on the previous page.
Search JabSto ::




Custom Search