MEDIAN function

  • Thread starter Thread starter Mr. Bill
  • Start date Start date
M

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
 
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
 
Back
Top