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 `=SUM(A1:A100)/COUNT(A1:A100)`

.

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.