Home / Blog / How to Use the MEDIAN Function in Google Sheets

How to Use the MEDIAN Function in Google Sheets

Sheets Header

Ought to it is advisable discover the center worth in a set of knowledge in your spreadsheet with out having to do it manually, Google Sheets has a perform that does it immediately for you. Right here’s use the MEDIAN perform.

Hearth up Google Sheets and open a spreadsheet with datasets for which you wish to discover the median.

Click on on an empty cell and sort =MEDIAN(<value1>, [<value2>, ...]) into the cell or the components entry area, changing <value1> and <value2> with the values or ranges to contemplate for calculating.

The MEDIAN perform in Google Sheets helps any variety of arguments, and something apart from the primary worth is elective. It should look one thing like this:


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 include the median of the numbers you place within the perform.

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

If you wish to use a variety of cells as values, it is going to appear like this:


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

After you press the “Enter” key, the cell will include the median worth of the vary you supplied to the perform.

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

Some issues to notice in regards to the MEDIAN perform: Something entered is sorted numerically, from the bottom to highest worth, and cells which might be empty—excluding “0”—and that include textual content might be ignored by the perform.

The MEDIAN perform returns the midmost worth in a numerical dataset if the set incorporates an odd variety of values. When you enter an excellent variety of values, the MEDIAN perform will estimate a response between the 2 middle values.

For instance, discover how we enter 36 values, none of that are “$31,” but the perform returns a median worth of “$31.” It’s because to seek out the median, the perform provides the center two numbers collectively after which divides by 2 to estimate the median. So, behind the scenes, it calculates (30 + 32) / 2 = 31 to provide the outcome.

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

About Brady Gavin

Check Also

How to Invert the Colors of Your Mac’s Screen

Khamosh Pathak When you’re taking a look at an app or a webpage in your …

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.