The MEDIAN function takes multiple arguments in the form number1, number2, number3, etc. Arguments can be a hardcoded constant, a cell reference, or a range, in any combination. MEDIAN ignores empty cells, text values, and the logical values TRUE and FALSE. The MEDIAN function will accept up to 255 separate arguments.
Examples
When the number of values provided is odd, MEDIAN returns the middle number: When the number of values provided is even, MEDIAN returns the average of the two middle numbers: In the worksheet shown above, the formulas in H5 and H6 are: Note that MEDIAN ignores the empty cell in D5:D16 and returns the middle number in the eleven values provided.
Notes
When the count of numbers is odd, MEDIAN returns the middle number. When the count of numbers is even, MEDIAN returns the average of the two middle numbers. MEDIAN ignores empty cells, the logical values TRUE and FALSE, and text. MEDIAN returns a #NUM! error if no numeric values are provided. Arguments can be numbers, names, arrays, or references, up to 255 total.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
