MEDIAN function

[Mr. Bill]

I need to select a series of values from a spreadsheet
based on a text criteria in the same spreadsheet and then
calculate the MEDIAN for those values selected.

I can use DAVERAGE, DMIN, and DMAX and it works fine. Is
there an equivalent function for MEDIAN

 

[Jason Morin]

You could use:

=MEDIAN(IF(A1:A6=E1,B1:B6))

Array-entered (press ctrl/shift/enter), where A1:A6 is the
range to evaluate, B1:B6 are the target values, and E1
holds the text value.

HTH
Jason
Atlanta, GA