Formula won't calculate

**tlosgyl3** · 01-24-2006, 03:50 PM

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** · 01-24-2006, 05:50 PM

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))}