After you’ve entered 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’ve created the formula you want, you can use the result in other calculations.
If necessary, select the cells with the data you want to summarize.
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".
18.222.20.20