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