Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula won't calculate
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=504617 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula won't calculate
Apologies posted twice -- tlosgyl3 ------------------------------------------------------------------------ tlosgyl3's Profile: http://www.excelforum.com/member.php...o&userid=28074 View this thread: http://www.excelforum.com/showthread...hreadid=504617 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate a formula once | Excel Worksheet Functions | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
Formula to calculate over-time | Excel Discussion (Misc queries) | |||
I need a formula to calculate the ratio of #'s in a row and column | Excel Discussion (Misc queries) | |||
X IN A CELL TO CALCULATE A FORMULA | Excel Worksheet Functions |