MEDIAN

The arguments in argument-list designate the values whose median is to be computed. If there is an even number of numbers in the set, MEDIAN calculates the average of the two numbers in the middle. Logical values and text representations of numbers entered directly into the list of arguments are included. If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value 0 are included.