To calculate the average of a dataset, you may use one of the following options:
1) divide the sum of the dataset by the number of values in this dataset (which is by definition how the average is to be calculated). The sum can be easily obtained with the function =SUM(...); the number of values is obtained with the function =COUNT(...), which counts the number of cells in the dataset that contain numbers (empty cells and cells which contain text are NOT counted). Type =SUM(...)/COUNT(...) and replace ... with the address of your dataset to get the average. In our example, type .
2) simply use the dedicated function =AVERAGE(...).
In our example, type =AVERAGE(A1:A100).
3) retrieve the average (and more) from the status bar at the bottom of the screen, while the dataset is selected. Three values are automatically displayed: the average, the number of cells containing numerical data (COUNT) and the sum.