Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Median of an Array
I have been trying to calculate the median of a set of data with two
stipulations. The first being that the cell in column T must be equal to 0.1. The 2nd stipulation is that the cell in column M must be greater that 0 but smaller than 100. If both of those statements can be deemed true, I want to calculate the median of those rows in column M. This database contains 91 entries. The current formula that I have looks like this: {=MEDIAN(IF(AND(T9:T100=0.1, M9:M100<100),M9:M100,""))} I am currently getting a #value error. Please help me!! Any feedback would be greatly appreciated. Thanks in advance, Kris Taylor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Median of an Array
{=MEDIAN(IF((T9:T100=0.1)*( M9:M100<100),M9:M100))}
-- Regards, Tom Ogilvy Kris Taylor wrote in message m... I have been trying to calculate the median of a set of data with two stipulations. The first being that the cell in column T must be equal to 0.1. The 2nd stipulation is that the cell in column M must be greater that 0 but smaller than 100. If both of those statements can be deemed true, I want to calculate the median of those rows in column M. This database contains 91 entries. The current formula that I have looks like this: {=MEDIAN(IF(AND(T9:T100=0.1, M9:M100<100),M9:M100,""))} I am currently getting a #value error. Please help me!! Any feedback would be greatly appreciated. Thanks in advance, Kris Taylor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Median Array | Excel Worksheet Functions | |||
Calculating Median Value in a large array | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
Median array formula | Excel Worksheet Functions | |||
MEDIAN() as array function? | Excel Worksheet Functions |