MEDIAN(number1,number2,…)
number1: first value
number2: second value
Strings and empty cells are simply ignored.
If even numbers are given MEDIAN returns the average of the two numbers in the center.
This function is Excel compatible.
AVERAGE, COUNT, COUNTA, DAVERAGE, MODE, SSMEDIAN, SUM.