MEDIAN function

 

The Klipfolio MEDIAN function calculates the median of all non-blank values.

The syntax for the MEDIAN function is:

MEDIAN( value )

MEDIAN example

Let's look at a MEDIAN function example.

 

A

B

1 Apples 5
2 Oranges 25
3 Pears  
5 Bananas 10

The following example is based on the above text from an Excel spreadsheet:

MEDIAN ( B:B )

-> [10]

Related links: