Sheets Header

Should you need to find the middle value in a set of data in your spreadsheet without having to do it manually, Google Sheets has a function that does it instantly for you. Here’s how to use the MEDIAN function.

Fire up Google Sheets and open a spreadsheet with datasets for which you want to find the median.

Click on an empty cell and type =MEDIAN(<value1>, [<value2>, ...]) into the cell or the formula entry field, replacing <value1> and <value2> with the values or ranges to consider for calculating.

The MEDIAN function in Google Sheets supports any number of arguments, and anything other than the first value is optional. It will look something like this:

=MEDIAN(1,2,5,7,7)

Enter the function into an empty cell with the numbers from which want to find the median value.

After you press the “Enter” key, the cell will now contain the median of the numbers you put in the function.

Press the "Enter" key and the median will appear in the cell.

If you want to use a range of cells as values, it will look like this:

=MEDIAN(F3:F11)

You can use ranges from your spreadsheet as well, just reference them in the function.

After you press the “Enter” key, the cell will contain the median value of the range you provided to the function.

Press "Enter" and the media value will replace the function.

Some things to note about the MEDIAN function: Anything entered is sorted numerically, from the lowest to highest value, and cells that are empty—excluding “0”—and that contain text will be ignored by the function.

The MEDIAN function returns the midmost value in a numerical dataset if the set contains an odd number of values. If you enter an even number of values, the MEDIAN function will estimate a response between the two center values.

For example, notice how we enter 36 values, none of which are “$31,” yet the function returns a median value of “$31.” This is because to find the median, the function adds the middle two numbers together and then divides by 2 to estimate the median. So, behind the scenes, it calculates (30 + 32) / 2 = 31 to produce the result.

The function will estimate a median if there is an even number of values entered. The estimated value is between the middle two values.

Brady Gavin Brady Gavin
Brady Gavin has been immersed in technology for 15 years and has written over 150 detailed tutorials and explainers. He's covered everything from Windows 10 registry hacks to Chrome browser tips. Brady has a diploma in Computer Science from Camosun College in Victoria, BC.  
Read Full Bio »