Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Median ignoring Zero Values
I have a Table 1 that extracts data from table 2 and table 3 to Table 1 columns A and B. Where Tables 2 and 3 contain no data Excel returns the balue 0 to table 1. The tables look like this: Table 1, Table 2, Table 3 Column A Column B Column A Column A +T2 Cell A1 +T3 Cell A1 Data Data Result Result m 4 m 4 f 6 f 6 f 8 f 8 0 0 0 0 With the data above and using the array formula =MEDIAN(IF($A$5:$A$90,IF($B$5:$B$90,$B$5:$B$9))) I get a correct result of 6. But if there is no Data in Table 3 Column A I get the result #NUM! As this data gets used to complile a further data set I need it to return 0 (Zero). Any help appreciated. tlosgyl3 I want to find the median of the values in column B of table 1 subject to 2 conditions: -- tlosgyl3 ------------------------------------------------------------------------ tlosgyl3's Profile: http://www.excelforum.com/member.php...o&userid=28074 View this thread: http://www.excelforum.com/showthread...hreadid=475831 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match function with duplicate values in an array | Excel Worksheet Functions | |||
Ignoring 0 values in the series data | Charts and Charting in Excel | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
ignoring null values in graph | Charts and Charting in Excel | |||
How do I do count calculations ignoring duplicate values | Excel Discussion (Misc queries) |