On the Formulas tab, click the arrow next to AutoSum, click Average, and then press RETURN.Ĭlick the cell that contains the average that you just created, cell A8 in this example.
Select the cell where you want the average to appear, such as cell A8, which is the cell to the left of the cell that contains the text 'Average unit quality' in the sample data. On the Formulas tab, click the arrow next to AutoSum, and then click Average.Ĭalculate the average for nonadjacent cells Select cells A2 through A7 (the values in the Unit Quality column).
In the sheet, select cell A1, and then press + V. A, B, C.) when you copy the sample data to a blank sheet.Īverage quality for all units rated above 5 Note: Do not select the row or column headings (1, 2, 3.
