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) |
Last edited: