Excel MEDIAN Function

Use:

Computes median of a set of data

Syntax:

MEDIAN( range )

Examples:

Cell D12 formula: MEDIAN( C4:G4 )

Cell D13 formula: MEDIAN( D3:D9 )
Cell D14 formula: MEDIAN( C3:G9 )
Cell D15 formula: MEDIAN( D3:D9,G3:G9 )

Related Functions:

AVERAGE, MODE, SUM, COUNT, COUNTA