Spreadsheet: 787690d1657965858-median-if-formula-not-working-median-if-data-set
Sheet: Sheet1

Yes | 7 |  |  |  | Yes | 7 | Yes |  |  | No |  | No
Yes | 4 |  |  |  | Yes | 4 |  |  |  | No
Yes | 1 |  |  |  | Yes | 1 |  |  |  | No
Yes | 3 |  |  |  | Yes | 3 |  |  |  | No | 0
Yes | 2 |  |  |  | Yes | 2 |  |  |  | No | 0
Yes | 4 |  |  |  | Yes | 4 |  |  |  | No
Yes | 1 |  |  |  | Yes | 1 |  |  |  | No | 16
No |  |  |  |  | Yes | 0 |  |  |  | No
Yes | 0 |  |  |  | Yes |  |  |  |  | No | 10
Yes |  |  |  |  | Yes |  |  |  |  | No | 6
Yes |  |  |  |  | Yes | 4 |  |  |  | No
Yes | 4 |  |  |  | Yes |  |  |  |  | No
Yes |  |  |  |  | Yes | 1 |  |  |  | No | 8
No |  |  |  |  | Yes | 6 |  |  |  | No | 9
No |  |  |  |  | Yes |  |  |  |  | No | 0
Yes | 1 |  |  |  | Yes |  |  |  |  | No
Yes | 6 |  |  |  | Yes | 0 |  |  |  | No
Yes |  |  |  |  | Yes | 0 |  |  |  | No
No | 0 |  |  |  | Yes | 25 |  |  |  | No
No | 0 |  |  |  | Yes |  |  |  |  | No
No |  |  |  |  | Yes | 0 |  |  |  | No | 28
Yes |  |  |  |  | Yes | 9 |  |  |  | No
No | 16 |  |  |  | Yes | 0 |  |  |  | No
Yes | 0 |  |  |  | Yes | 16 |  |  |  | No | 8
Yes | 0 |  |  |  | Yes | 1 |  |  |  | No | 18
Yes | 25 |  |  |  | Yes | 24 |  |  |  | No | 13
Yes |  |  |  |  | Yes | 2 |  |  |  | No
Yes | 0 |  |  |  | Yes |  |  |  |  | No | 1
Yes | 9 |  |  |  | Yes | 5 |  |  |  | No | 18
Yes | 0 |  |  |  | Yes | 1 |  |  |  | No | 9
No |  |  |  |  | Yes | 10 |  |  |  | No | 5
Yes | 16 |  |  |  | Yes | 0 |  |  |  | No | 1
Yes | 1 |  |  |  | Yes | 10 |  |  |  | No | 0
Yes | 24 |  |  |  | Yes | 4 |  |  |  | No
Yes | 2 |  |  |  | Yes | 0 |  |  |  | No | 3
Yes |  |  |  |  | Yes |  |  |  |  | No | 7
Yes | 5 |  |  |  | Yes | 2 |  |  |  | No
No | 10 |  |  |  | Yes |  |  |  |  | No | 12
No | 6 |  |  |  | Yes | 0 |  |  |  | No | 1
Yes | 1 |  |  |  | Yes | 23 |  |  |  | No | 3
Yes | 10 |  |  |  | Yes | 10 |  |  |  | No | 27
No |  |  |  |  | Yes | 6 |  |  |  | No | 0
Yes | 0 |  |  |  | Yes | 10 |  |  |  | No | 1
Yes | 10 |  |  |  | Yes | 29 |  |  |  | No | 28
Yes | 4 |  |  |  | Yes | 0 |  |  |  | No
Yes | 0 |  |  |  | Yes | 6 |  |  |  | No | 4
No |  |  |  |  | Yes | 3 |  |  |  | No | 7
No | 8 |  |  |  | Yes |  |  |  |  | No | 24
Yes |  |  |  |  | Yes | 8 |  |  |  | No | 0
Yes | 2 |  |  |  | Yes | 0 |  |  |  | No | 28
Yes |  |  |  |  | Yes | 10 |  |  |  | No
Yes | 0 |  |  |  | Yes | 2 |  |  |  | No | 4
No | 9 |  |  |  | Yes | 3 |  |  |  | No
Yes | 23 |  |  |  | Yes | 0 |  |  |  | No | 30
Yes | 10 |  |  |  | Yes | 1 |  |  |  | No | 1
No | 0 |  |  |  | Yes |  |  |  |  | No
No |  |  |  |  | Yes | 1 |  |  |  | No | 0
No |  |  |  |  | Yes | 28 |  |  |  | No | 0
No |  |  |  |  | Yes | 3 |  |  |  | No | 3
No |  |  |  |  | Yes | 3 |  |  |  | No | 9
Yes | 6 |  |  |  | Yes | 2 |  |  |  | No | 3
Yes | 10 |  |  |  | Yes | 5 |  |  |  | No | 0
No |  |  |  |  | Yes |  |  |  |  | No | 37
Yes | 29 |  |  |  | Yes | 0 |  |  |  | No
Yes | 0 |  |  |  | Yes |  |  |  |  | No
Yes | 6 |  |  |  | Yes | 4 |  |  |  | No | 4
No | 28 |  |  |  | Yes | 2 |  |  |  | No
Yes | 3 |  |  |  | Yes |  |  |  |  | No
No |  |  |  |  | Yes | 0 |  |  |  | No | 2
Yes |  |  |  |  | Yes |  |  |  |  | No | 2
Yes | 8 |  |  |  | Yes | 6 |  |  |  | No
Yes | 0 |  |  |  | Yes | 11 |  |  |  | No
No |  |  |  |  | Yes |  |  |  |  | No | 5
No | 8 |  |  |  | Yes |  |  |  |  | No
Yes | 10 |  |  |  | Yes | 0 |  |  |  | No
No | 18 |  |  |  | Yes | 0 |  |  |  | No
Yes | 2 |  |  |  | Yes | 0 |  |  |  | No
Yes | 3 |  |  |  | Yes | 4 |  |  |  | No | 15
No | 13 |  |  |  | Yes | 0 |  |  |  | No
Yes | 0 |  |  |  | Yes | 2 |  |  |  | No
Yes | 1 |  |  |  | Yes | 0 |  |  |  | No | 0
Yes |  |  |  |  | Yes | 26 |  |  |  | No
No |  |  |  |  | Yes | 15 |  |  |  | No | 6
Yes | 1 |  |  |  | Yes | 12 |  |  |  | No | 20
Yes | 28 |  |  |  | Yes | 2 |  |  |  | No
Yes | 3 |  |  |  | Yes | 0 |  |  |  | No
Yes | 3 |  |  |  | Yes |  |  |  |  | No | 0
Yes | 2 |  |  |  | Yes | 3 |  |  |  | No
Yes | 5 |  |  |  | Yes | 3 |  |  |  | No
Yes |  |  |  |  | Yes | 11 |  |  |  | No | 28
Yes | 0 |  |  |  | Yes | 15 |  |  |  | No
No | 1 |  |  |  | Yes | 0 |  |  |  | No
No | 18 |  |  |  | Yes | 5 |  |  |  | No
Yes |  |  |  |  | Yes | 29 |  |  |  | No
Yes | 4 |  |  |  | Yes |  |  |  |  | No
No | 9 |  |  |  | Yes |  |  |  |  | No
Yes | 2 |  |  |  | Yes | 7 |  |  |  | No
Yes |  |  |  |  | Yes | 2 |  |  |  | No | 3
No | 5 |  |  |  | Yes | 4 |  |  |  | No
Yes | 0 |  |  |  | Yes |  |  |  |  | No | 0
Yes |  |  |  |  | Yes |  |  |  |  | No | 0
No | 1 |  |  |  | Yes |  |  |  |  | No | 43
No | 0 |  |  |  | Yes |  |  |  |  | No | 8
No |  |  |  |  | Yes | 8 |  |  |  | No | 0
Yes | 6 |  |  |  | Yes |  |  |  |  | No | 6
No | 3 |  |  |  | Yes | 8 |  |  |  | No | 9
No | 7 |  |  |  | Yes |  |  |  |  | No | 3
No |  |  |  |  | Yes | 1 |  |  |  | No | 0
Yes | 11 |  |  |  | Yes |  |  |  |  | No
Yes |  |  |  |  | Yes |  |  |  |  | No | 0
Yes |  |  |  |  | Yes | 0 |  |  |  | No
Yes | 0 |  |  |  | Yes | 21 |  |  |  | No
Yes | 0 |  |  |  | Yes |  |  |  |  | No | 0
No | 12 |  |  |  | Yes | 5 |  |  |  | No | 31
Yes | 0 |  |  |  | Yes | 0 |  |  |  | No | 35
Yes | 4 |  |  |  | Yes |  |  |  |  | No | 31
Yes | 0 |  |  |  | Yes |  |  |  |  | No
No | 1 |  |  |  | Yes | 0 |  |  |  | No
No | 3 |  |  |  | Yes |  |  |  |  | No
Yes | 2 |  |  |  | Yes | 2 |  |  |  | No | 0
No | 27 |  |  |  | Yes |  |  |  |  | No | 6
Yes | 0 |  |  |  | Yes | 6 |  |  |  | No
Yes | 26 |  |  |  | Yes | 5 |  |  |  | No | 23
Yes | 15 |  |  |  | Yes |  |  |  |  | No | 0
No | 0 |  |  |  | Yes | 18 |  |  |  | No | 16
No | 1 |  |  |  | Yes |  |  |  |  | No
Yes | 12 |  |  |  | Yes | 0 |  |  |  | No
Yes | 2 |  |  |  | Yes | 4 |  |  |  | No | 4
Yes | 0 |  |  |  | Yes | 0 |  |  |  | No
No | 28 |  |  |  | Yes | 13 |  |  |  | No | 26
No |  |  |  |  | Yes | 4 |  |  |  | No
No | 4 |  |  |  | Yes |  |  |  |  | No
Yes |  |  |  |  | Yes | 0 |  |  |  | No | 1
Yes | 3 |  |  |  | Yes | 13 |  |  |  | No
Yes | 3 |  |  |  | Yes |  |  |  |  | No
Yes | 11 |  |  |  | Yes |  |  |  |  | No | 0
Yes | 15 |  |  |  | Yes |  |  |  |  | No | 2
Yes | 0 |  |  |  | Yes | 7 |  |  |  | No | 1
Yes | 5 |  |  |  | Yes | 0 |  |  |  | No | 2
No | 7 |  |  |  | Yes
Yes | 29 |  |  |  | Yes
No | 24 |  |  |  | Yes | 0
Yes |  |  |  |  | Yes | 4
Yes |  |  |  |  | Yes
Yes | 7 |  |  |  | Yes
No | 0 |  |  |  | Yes
Yes | 2 |  |  |  | Yes | 0
Yes | 4 |  |  |  | Yes | 0
Yes |  |  |  |  | Yes | 7
Yes |  |  |  |  | Yes | 25
No | 28 |  |  |  | Yes
No |  |  |  |  | Yes | 3
Yes |  |  |  |  | Yes | 1
Yes |  |  |  |  | Yes | 24
No | 4 |  |  |  | Yes
No |  |  |  |  | Yes
Yes | 8 |  |  |  | Yes
No | 30 |  |  |  | Yes | 2
No | 1 |  |  |  | Yes | 0
Yes |  |  |  |  | Yes | 7
Yes | 8 |  |  |  | Yes | 0
No |  |  |  |  | Yes | 23
Yes |  |  |  |  | Yes | 0
Yes | 1 |  |  |  | Yes
No | 0 |  |  |  | Yes | 0
No | 0 |  |  |  | Yes | 2
Yes |  |  |  |  | Yes
No | 3 |  |  |  | Yes
No | 9 |  |  |  | Yes | 1
No | 3 |  |  |  | Yes | 1
Yes |  |  |  |  | Yes | 5
Yes | 0 |  |  |  | Yes | 0
Yes | 21 |  |  |  | Yes | 1
Yes |  |  |  |  | Yes | 19
Yes | 5 |  |  |  | Yes | 6
Yes | 0 |  |  |  | Yes
Yes |  |  |  |  | Yes | 0
Yes |  |  |  |  | Yes
Yes | 0 |  |  |  | Yes
No | 0 |  |  |  | Yes | 0
Yes |  |  |  |  | Yes | 2
No | 37 |  |  |  | Yes | 0
Yes | 2 |  |  |  | Yes | 0
No |  |  |  |  | Yes | 5
Yes |  |  |  |  | Yes
Yes | 6 |  |  |  | Yes | 1
No |  |  |  |  | Yes | 3
No | 4 |  |  |  | Yes | 8
No |  |  |  |  | Yes | 7
Yes | 5 |  |  |  | Yes | 0
Yes |  |  |  |  | Yes | 18
Yes | 18 |  |  |  | Yes | 2
No |  |  |  |  | Yes | 4
Yes |  |  |  |  | Yes | 19
Yes | 0 |  |  |  | Yes | 16
Yes | 4 |  |  |  | Yes | 18
No | 2 |  |  |  | Yes | 14
No | 2 |  |  |  | Yes | 12
Yes | 0 |  |  |  | Yes | 12
Yes | 13 |  |  |  | Yes | 12
Yes | 4 |  |  |  | Yes | 0
Yes |  |  |  |  | Yes | 0
Yes | 0 |  |  |  | Yes | 1
Yes | 13 |  |  |  | Yes | 6
Yes |  |  |  |  | Yes | 16
Yes |  |  |  |  | Yes | 0
No |  |  |  |  | Yes | 3
No |  |  |  |  | Yes | 0
No | 5 |  |  |  | Yes | 24
Yes |  |  |  |  | Yes | 9
Yes | 7 |  |  |  | Yes | 3
Yes | 0 |  |  |  | Yes | 0
Yes |  |  |  |  | Yes | 0
Yes |  |  |  |  | Yes | 4
No |  |  |  |  | Yes | 31
Yes | 0 |  |  |  | Yes | 3
No |  |  |  |  | Yes | 2
No |  |  |  |  | Yes | 2
Yes | 4 |  |  |  | Yes
Yes |  |  |  |  | Yes | 2
No |  |  |  |  | Yes
No | 15 |  |  |  | Yes | 8
No |  |  |  |  | Yes | 1
Yes |  |  |  |  | Yes | 1
Yes |  |  |  |  | Yes
Yes | 0 |  |  |  | Yes
Yes | 0 |  |  |  | Yes | 7
Yes | 7 |  |  |  | Yes | 0
Yes | 25 |  |  |  | Yes | 4
Yes |  |  |  |  | Yes | 22
Yes | 3 |  |  |  | Yes | 0
Yes | 1 |  |  |  | Yes | 5
Yes | 24 |  |  |  | Yes | 0
Yes |  |  |  |  | Yes | 3
No |  |  |  |  | Yes | 0
Yes |  |  |  |  | Yes | 0
No | 0 |  |  |  | Yes | 0
Yes |  |  |  |  | Yes | 9
Yes | 2 |  |  |  | Yes | 10
Yes | 0 |  |  |  | Yes | 2
No |  |  |  |  | Yes | 3
Yes | 7 |  |  |  | Yes | 3
Yes | 0 |  |  |  | Yes | 2
No | 6 |  |  |  | Yes | 33
Yes | 23 |  |  |  | Yes | 0
Yes | 0 |  |  |  | Yes | 15
No | 20 |  |  |  | Yes | 2
Yes |  |  |  |  | Yes
No |  |  |  |  | Yes | 4
No |  |  |  |  | Yes | 12
Yes | 0 |  |  |  | Yes | 0
No | 0 |  |  |  | Yes | 17
Yes | 2 |  |  |  | Yes | 1
Yes |  |  |  |  | Yes | 1
Yes |  |  |  |  | Yes | 2
Yes | 1 |  |  |  | Yes | 0
Yes | 1 |  |  |  | Yes | 0
No |  |  |  |  | Yes | 0
Yes | 5 |  |  |  | Yes
Yes | 0 |  |  |  | Yes | 0
No |  |  |  |  | Yes | 4
Yes | 1 |  |  |  | Yes | 6
Yes | 19 |  |  |  | Yes
No | 28 |  |  |  | Yes | 27
Yes | 6 |  |  |  | Yes | 14
Yes |  |  |  |  | Yes
Yes | 0 |  |  |  | Yes | 3
Yes |  |  |  |  | Yes | 2
Yes |  |  |  |  | Yes | 5
Yes | 0 |  |  |  | Yes | 4
Yes | 2 |  |  |  | Yes | 1
Yes | 0 |  |  |  | Yes
Yes | 0 |  |  |  | Yes | 3
Yes | 5 |  |  |  | Yes | 2
No |  |  |  |  | Yes | 2
No |  |  |  |  | Yes | 0
Yes |  |  |  |  | Yes
No |  |  |  |  | Yes | 1
No |  |  |  |  | Yes
Yes | 1 |  |  |  | Yes
Yes | 3 |  |  |  | Yes
Yes | 8 |  |  |  | Yes | 2
No |  |  |  |  | Yes | 13
No |  |  |  |  | Yes
No |  |  |  |  | Yes | 8
No | 3 |  |  |  | Yes
Yes | 7 |  |  |  | Yes | 3
Yes | 0 |  |  |  | Yes
No |  |  |  |  | Yes | 1
Yes | 18 |  |  |  | Yes | 6
Yes | 2 |  |  |  | Yes | 7
Yes | 4 |  |  |  | Yes | 5
Yes | 19 |  |  |  | Yes | 1
No | 0 |  |  |  | Yes
No | 0 |  |  |  | Yes
Yes | 16 |  |  |  | Yes | 0
Yes | 18 |  |  |  | Yes
Yes | 14 |  |  |  | Yes
Yes | 12 |  |  |  | Yes | 2
Yes | 12 |  |  |  | Yes
Yes | 12 |  |  |  | Yes | 9
Yes | 0 |  |  |  | Yes | 26
Yes | 0 |  |  |  | Yes | 3
No | 43 |  |  |  | Yes
Yes | 1 |  |  |  | Yes | 22
Yes | 6 |  |  |  | Yes | 0
Yes | 16 |  |  |  | Yes | 15
Yes | 0 |  |  |  | Yes | 2
Yes | 3 |  |  |  | Yes | 0
Yes | 0 |  |  |  | Yes
No | 8 |  |  |  | Yes | 5
Yes | 24 |  |  |  | Yes
Yes | 9 |  |  |  | Yes | 1
Yes | 3 |  |  |  | Yes | 0
No | 0 |  |  |  | Yes
Yes | 0 |  |  |  | Yes | 2
Yes | 0 |  |  |  | Yes | 2
No | 6 |  |  |  | Yes
Yes | 4 |  |  |  | Yes
Yes | 31 |  |  |  | Yes | 0
No | 9 |  |  |  | Yes | 0
No | 3 |  |  |  | Yes | 2
Yes | 3 |  |  |  | Yes | 1
No | 0 |  |  |  | Yes | 2
Yes | 2 |  |  |  | Yes
Yes | 2 |  |  |  | Yes
Yes |  |  |  |  | Yes | 1
No |  |  |  |  | Yes | 6
No | 0 |  |  |  | Yes | 0
No |  |  |  |  | Yes | 0
Yes | 2 |  |  |  | Yes | 3
Yes |  |  |  |  | Yes | 15
Yes | 8 |  |  |  | Yes | 14
Yes | 1 |  |  |  | Yes
No
Yes | 1
Yes
Yes
Yes | 7
Yes | 0
Yes | 4
Yes | 22
No | 0
Yes | 0
No | 31
Yes | 5
Yes | 0
Yes | 3
No | 35
Yes | 0
Yes | 0
Yes | 0
Yes | 9
Yes | 10
Yes | 2
No | 31
Yes | 3
Yes | 3
Yes | 2
Yes | 33
Yes | 0
Yes | 15
Yes | 2
Yes
Yes | 4
Yes | 12
Yes | 0
Yes | 17
No
Yes | 1
No
No
Yes | 1
Yes | 2
No | 0
No | 6
Yes | 0
Yes | 0
Yes | 0
Yes
Yes | 0
Yes | 4
No
Yes | 6
Yes
Yes | 27
Yes | 14
No | 23
Yes
Yes | 3
Yes | 2
Yes | 5
Yes | 4
Yes | 1
No | 0
Yes
Yes | 3
Yes | 2
Yes | 2
Yes | 0
Yes
Yes | 1
No | 16
No
No
Yes
Yes
Yes
No | 4
Yes | 2
Yes | 13
No
Yes
Yes | 8
No | 26
No
Yes
Yes | 3
Yes
Yes | 1
Yes | 6
Yes | 7
Yes | 5
Yes | 1
Yes
Yes
Yes | 0
Yes
Yes
No
Yes | 2
Yes
No | 1
Yes | 9
No
Yes | 26
No
No | 0
Yes | 3
Yes
Yes | 22
Yes | 0
Yes | 15
Yes | 2
Yes | 0
Yes
Yes | 5
Yes
Yes | 1
Yes | 0
Yes
Yes | 2
Yes | 2
No | 2
Yes
Yes
Yes | 0
Yes | 0
Yes | 2
Yes | 1
Yes | 2
Yes
Yes
Yes | 1
No | 1
No | 2
Yes | 6
Yes | 0
Yes | 0
Yes | 3
Yes | 15
Yes | 14
Yes