T
tlosgyl3
I have a Table 1 that extracts data from table 2 and table 3 to Table
columns A and B.
Where Tables 2 and 3 contain no data Excel returns the balue 0 to tabl
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 arra
formula =MEDIAN(IF($A$5:$A$9>0,IF($B$5:$B$9>0,$B$5:$B$9)))
I get a correct result of 6. But if there is no Data in Table 3 Colum
A I get the result #NUM!
As this data gets used to complile a further data set I need it t
return 0 (Zero).
Any help appreciated.
tlosgyl3
I want to find the median of the values in column B of table 1 subjec
to 2 conditions
columns A and B.
Where Tables 2 and 3 contain no data Excel returns the balue 0 to tabl
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 arra
formula =MEDIAN(IF($A$5:$A$9>0,IF($B$5:$B$9>0,$B$5:$B$9)))
I get a correct result of 6. But if there is no Data in Table 3 Colum
A I get the result #NUM!
As this data gets used to complile a further data set I need it t
return 0 (Zero).
Any help appreciated.
tlosgyl3
I want to find the median of the values in column B of table 1 subjec
to 2 conditions