SumIF
I would like to be able to use the same type of functionallity given with the
sum if function, but instead of returning the sum, return the median? Some
example data follows:
Column A Column B
B1 175
B1 200
B1 225
I would like the formula to use Column A as the column to evaluate, and
return the median of column B based on the criteria (in this case it would be
the median of 200 for the values in column B based on B1 in column A
Any ideas? Thanks.
|