Updated: 10/02/2017 by Computer Hope

The median is the sum of a group of numbers, divided by how many numbers are in the group. For example, the median of the values 1, 2, 3, 4, 5, 6, and 7 is 4, because 1+2+3+4+5+6+7 is 28, and 28 divided by 7 is 4.

In Microsoft Excel, the function below, when placed in a cell, will automatically fill that cell with the median of the values in cells A1 through A7.


Average, Mode, Spreadsheet terms