Median of two different sets of data

[tony0682]

Looking for help trying to calculate the median of both sets of numbers in B18. The formula should only include numbers with a positive value in column C. Any help is appreciated.

Book1
	A	B	C
1		20	1
2		15	-2
3		8	2
4		16	3
5		6	6
6		12	-1
7	Set A Median	13.5
8
9		13	9
10		20	4
11		12	6
12		15	3
13		9	2
14		4	4
15		11	-5
16	Set B Median	11.5
17
18	Median of Both Sets
Sheet1

Cell Formulas
Range	Formula
B7	=MEDIAN(B1:B6)
B16	=MEDIAN(B10:B15)

 

[shg]

	A​	B​	C​	D​
1​		20​	1​
2​		15​	-2​
3​		8​	2​
4​		16​	3​
5​		6​	6​
6​		12​	-1​
7​	Set A Median	12​		B7: {=MEDIAN(IF(C1:C6 > 0,B1:B6))}
8​
9​		13​	9​
10​		20​	4​
11​		12​	6​
12​		15​	3​
13​		9​	2​
14​		4​	4​
15​		11​	-5​
16​	Set B Median	12.5​		B16: {=MEDIAN(IF(C9:C15 > 0,B9:B15))}
17​
18​	Median of Both Sets	12.5​		B18: {=MEDIAN(IF(C1:C6 > 0, B1:B6), IF(C9:C15 > 0, B9:B15))}