MEDIAN in Zoho Sheet: Median, Outliers and Even Counts

Use MEDIAN in Zoho Sheet to find the middle of a numeric data set, averaging the two central observations when the count is even. The working example below describes ticket handling 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 Zoho Sheet.

MEDIAN(number; [number1]; ...)

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 browser-based service register with one row per handled ticket provides the scenario. Enter the following numeric observations into A2:A10, one per row, with a header in A1. Use a spare result cell outside the input range.

Download the Zoho Sheet 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:A10)

Expected result: 12.

The ordered observations are 2, 6, 10, 10, 12, 14, 14, 18, 22. There are 9 observations, so position 5 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 Zoho reference documents the MEDIAN name and its worksheet inputs.

Zoho documents text, logical values and empty cells as ignored for this function. These examples still use numeric-only data so the expected result is not dependent on a particular import converting text to a number. See the function-specific Zoho help.

The formulas follow Zoho’s documented semicolon-separated form. Do not replace the colon inside a range such as A2:A10: it still means all the cells between those endpoints. If your configured editor expects a different argument separator, use the one it displays.

In the service-register example, keep ticket handling time separate from time waiting for a customer. Record one intended observation per row before summarising the list. The function cannot tell which part of a ticket lifecycle a number represents. Native Zoho runs, mixed-type coercion tests and desktop/mobile comparisons are outside this guide’s verification scope.

For the same statistical question in other programs, see MEDIAN in Microsoft Excel, MEDIAN in Google Sheets, MEDIAN in ONLYOFFICE. 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, STDEVP, VAR, VARP. Browse the Zoho Sheet function library for the other published guides.

Editorial verification: The vendor documentation was reviewed on 2026-10-12. Scope: Zoho Sheet public web help and its documented English formula names. Desktop/mobile parity and first-release dates have not been established here. 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.