Formula won't calculate

[tlosgyl3]

I have the following expressions in adjacent cells
{=IF(L3:L62>0,MEDIAN(IF(L3:L62>0,L3:L62)),0)}
{=IF(M3:M62>0,MEDIAN(IF(M3:M62>0,M3:M62)),0)}

The data from which it is trying to calculae the Median is extracted
from another sheet.

I want to know the median value of those cells where the value is above
0

The first expression calculates correctly
The second consitently returns 0 even though there are positive values
in 44 of the cells.

Any ideas?http://www.excelforum.com/images/smilies/confused.gif


tlosgyl3

 

[daddylonglegs]

You need to change the formulas - the ones you have will only give you
the result you want when L3 (or M3) has a positive value.You only need

{=MEDIAN(IF(L3:L62>0,L3:L62))}
{=MEDIAN(IF(M3:M62>0,M3:M62))}

 

[tlosgyl3]

Got it - works - brillaint - thanks

tlosgyl3