Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
sumif based on vlookup array | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |