MEDIAN in Google Sheets: Median, Outliers and Even Counts

Use MEDIAN in Google Sheets to find the middle of a numeric data set, averaging the two central observations when the count is even. The working example below describes support resolution times; its result is measured in minutes. The official reference supports the function’s identity and purpose.

This guide separates documentation review from application testing. The expected numbers are independently calculated, not screenshots or results captured from Google Sheets.

MEDIAN(value1, [value2, ...])

Numeric inputs: individual numbers or cell ranges holding the observations. One range can contain many observations; a header is not a measurement.

Additional inputs: optional extra numeric values or ranges. Omit the square brackets shown in the syntax notation when entering a formula. The numeric-only examples avoid relying on text or logical-value conversion.

Use the median when the question is about a typical observation rather than a total. An unusually large observation can pull an arithmetic mean far away from most records. The middle position answers a different question and is worth showing alongside the mean, not treating as a replacement in every report.

A median does not measure variability. Two lists can have the same median while one has much more extreme observations. It also cannot recover a combined median from subgroup medians alone: retain the underlying observations when combining groups.

A shared support log with one row per resolved ticket provides the scenario. Enter the following numeric observations into A2:A8, one per row, with a header in A1. Use a spare result cell outside the input range.

Download the Google Sheets MEDIAN practice data (CSV). Import it into a new, blank sheet starting at A1, with a comma as the file delimiter and the header row retained. The CSV contains input values only, not formulas or native test results. Blank spacer columns place the requested position in D2 and any additional test data in column F. Keep observations numeric rather than importing them as text.

Example 1: Find the middle of the working register

=MEDIAN(A2:A8)

Expected result: 10.

The ordered observations are 7, 8, 9, 10, 12, 12, 15. There are 7 observations, so position 4 supplies the middle value.

Example 2: Check an odd count with a high outlier

=MEDIAN(3,5,7,9,101)

Expected result: 7.

The third of these five ordered values is 7. The unusually large last value changes the mean much more than it changes this middle position. These are literal numbers, not text strings.

Example 3: Keep a real zero in an even-sized group

For this check, use F2:F5 containing 0, 2, 8, 10, in that order. These values are included in the practice file.

=MEDIAN(F2:F5)

Expected result: 5.

The central values are 2 and 8, so their average is 5, even though 5 does not appear in the list. Removing the measured zero would leave three values and change the median to 8.

For odd n, select ordered position (n + 1)/2. For even n, average positions n/2 and n/2 + 1. This positional definition explains both the odd-count and even-count examples without changing the order of the input register. Keep stored results at full available precision and round only the final presentation when a report requires it. The displayed expectations above are rounded where necessary; a different number of displayed decimal places is not by itself a calculation error.

The result is not present in the data. That is normal for an even count: the median can lie between the two central values. Do not replace it with the nearest observed value unless your reporting rule explicitly requires that different statistic.

A numeric count unexpectedly changes. Examine imported numbers, blank cells and zero values separately. A missing measurement and a measured zero have different meanings. The examples use numeric cells so they do not rely on text-conversion behaviour.

A summary of group medians seems wrong. The median of medians is generally not the median of all original observations. Recalculate from the original records when possible, with the intended inclusion rule documented.

The Google Sheets reference documents this function for worksheet data.

The support-log example uses ordinary worksheet cells, not a BigQuery data column. Some Google help pages also show Connected Sheets syntax; that is not the syntax being demonstrated here. A ticket’s duration is entered as a number of minutes, not as a time-of-day text label.

For a shared log, agree on whether reopened tickets form new observations and whether each row represents one ticket or one agent action. Keep that decision consistent before comparing reporting periods. When collaborators paste data, inspect a small sample of numeric cells and confirm the selected range still ends at the intended row.

The examples use English function names and commas. Adjust the argument separator to the file’s locale as needed, while keeping decimal values and cell references intact. No import/export or native Google Sheets execution was performed for this guide.

For the same statistical question in other programs, see MEDIAN in Microsoft Excel, MEDIAN in ONLYOFFICE, MEDIAN in SoftMaker PlanMaker. These links identify corresponding measures, not a guarantee that names, mixed-data rules, error codes or file conversions are identical.

LARGE, SMALL, RANK.EQ, STDEV.S, STDEV.P, VAR.S, VAR.P. Browse the Google Sheets function library for the other published guides.

Editorial verification: The vendor documentation was reviewed on 2026-10-12. Scope: Ordinary Google Sheets cells using English function names. Connected Sheets / BigQuery column syntax is outside this guide. Three numeric examples were checked with an independent arithmetic model. No native application run was performed. Single-value population edge cases, mixed-data coercion, exact error-code parity and round-trip workbook compatibility remain untested; they are not labelled application-verified.