I have the following expressions in adjacent cells
{=IF(L3:L620,MEDIAN(IF(L3:L620,L3:L62)),0)}
{=IF(M3:M620,MEDIAN(IF(M3:M620,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


--
tlosgyl3
------------------------------------------------------------------------
tlosgyl3's Profile: http://www.excelforum.com/member.php...o&userid=28074
View this thread: http://www.excelforum.com/showthread...hreadid=504605

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:L620,L3:L62))}
{=MEDIAN(IF(M3:M620,M3:M62))}


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=504605

Got it - works - brillaint - thanks :)

tlosgyl3


--
tlosgyl3
------------------------------------------------------------------------
tlosgyl3's Profile: http://www.excelforum.com/member.php...o&userid=28074
View this thread: http://www.excelforum.com/showthread...hreadid=504605