The syntax of the MEDIAN function
The first argument, number1, is required. It can be a typed number, a cell reference, or a logical statement.
number2 is the exactly the same, but it’s optional. MEDIAN can take up to 255 arguments, though you’ll usually apply it to a cell range.
The median is the number that appears in the middle of the list. In the sequence 10, 12, 15, 16, 17, the median is 15.
(We’ll talk about what happens when you have an even number of entries in a moment.)