The AVERAGE function calculates the mean average of a group of numbers. To use the AVERAGE function, follow these steps:
Google Spreadsheets now calculates the mean for the selected cells and inserts that average into the current cell. Note The AVERAGE function in Google Spreadsheets calculates the arithmetic mean. You calculate the mean by totaling a range of cells, then dividing the total by the number of cells in the range. For example, if you had three cells with the values 1, 2, and 3, the total would be 6, the number of cells (the COUNT) would be 3, and the mean (AVERAGE) would be 6/3, or 2. |