1. Calculate the average

To calculate the average of a dataset, you may use one of the following options:


Skjermbilde 2016-11-28 22.24.351) 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 .


Skjermbilde 2016-11-28 22.25.472) simply use the dedicated function =AVERAGE(...).
In our example, type =AVERAGE(A1:A100).



Skjermbilde 2016-11-28 22.28.443) 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.

  Fant du det du lette etter? Did you find this helpful?
[Average: 0]