It calculates the sum of the cells and then divides that value by the number of cells in the argument. If you are looking for the word test for example in cell A2 type the following. In your case youll want to use the following formula.
Select the cell where you want to.
Figures do not show up on the bottom for SUM and AVERAGE but the COUNT does. This function determines the average of the values included in the argument. Calculates the number of days months or years between two dates. Head over to Formulas Under formula Auditing Click on Show Formulas With the first click formulas will show up and Second click they will hide behind cells and start working Please refer above screenshot Also read.