Spreadsheet: 273915d1382965123-count-if-array-incl-blank-values-as-criteria-not-working-aug22guide-v4
Sheet: OverP table

Price | Margin over which it is not OverP | Position beyond which it is not OverP
1.01 | -40 | 1 |  | 1.01
1.02 | -40 | 1 |  | 1.02
1.03 | -30 | 1 |  | 1.03
1.04 | -30 | 1 |  | 1.04
1.05 | -30 | 1 |  | 1.05
1.06 | -30 | 1 |  | 1.06
1.07 | -30 | 1 |  | 1.07
1.08 | -30 | 1 |  | 1.08
1.09 | -30 | 1 |  | 1.09
1.1 | -20 | 1 |  | 1.1
1.11 | -20 | 1 |  | 1.11
1.12 | -20 | 1 |  | 1.12
1.13 | -20 | 1 |  | 1.13
1.14 | -20 | 1 |  | 1.14
1.15 | -20 | 1 |  | 1.15
1.16 | -20 | 1 |  | 1.16
1.17 | -20 | 1 |  | 1.17
1.18 | -20 | 1 |  | 1.18
1.19 | -20 | 1 |  | 1.19
1.2 | -20 | 1 |  | 1.2
1.21 | -15 | 1 |  | 1.21
1.22 | -15 | 1 |  | 1.22
1.23 | -15 | 1 |  | 1.23
1.24 | -15 | 1 |  | 1.24
1.25 | -15 | 1 |  | 1.25
1.26 | -15 | 1 |  | 1.26
1.27 | -15 | 1 |  | 1.27
1.28 | -15 | 1 |  | 1.28
1.29 | -15 | 1 |  | 1.29
1.3 | -15 | 1 |  | 1.3
1.31 | -15 | 1 |  | 1.31
1.32 | -15 | 1 |  | 1.32
1.33 | -15 | 1 |  | 1.33
1.34 | -15 | 1 |  | 1.34
1.35 | -15 | 1 |  | 1.35
1.36 | -15 | 1 |  | 1.36
1.37 | -15 | 1 |  | 1.37
1.38 | -15 | 1 |  | 1.38
1.39 | -15 | 1 |  | 1.39
1.4 | -10 | 1 |  | 1.4
1.41 | -10 | 1 |  | 1.41
1.42 | -10 | 1 |  | 1.42
1.43 | -10 | 1 |  | 1.43
1.44 | -10 | 1 |  | 1.44
1.45 | -10 | 1 |  | 1.45
1.46 | -10 | 1 |  | 1.46
1.47 | -10 | 1 |  | 1.47
1.48 | -10 | 1 |  | 1.48
1.49 | -10 | 1 |  | 1.49
1.5 | -10 | 1 |  | 1.5
1.51 | -10 | 1 |  | 1.51
1.52 | -10 | 1 |  | 1.52
1.53 | -10 | 1 |  | 1.53
1.54 | -10 | 1 |  | 1.54
1.55 | -10 | 1 |  | 1.55
1.56 | -10 | 1 |  | 1.56
1.57 | -10 | 1 |  | 1.57
1.58 | -10 | 1 |  | 1.58
1.59 | -10 | 1 |  | 1.59
1.6 | -8 | 1 |  | 1.6
1.61 | -8 | 1 |  | 1.61
1.62 | -8 | 1 |  | 1.62
1.63 | -8 | 1 |  | 1.63
1.64 | -8 | 1 |  | 1.64
1.65 | -8 | 1 |  | 1.65
1.66 | -8 | 1 |  | 1.66
1.67 | -8 | 1 |  | 1.67
1.68 | -8 | 1 |  | 1.68
1.69 | -8 | 1 |  | 1.69
1.7 | -8 | 1 |  | 1.7
1.71 | -8 | 1 |  | 1.71
1.72 | -8 | 1 |  | 1.72
1.73 | -8 | 1 |  | 1.73
1.74 | -8 | 1 |  | 1.74
1.75 | -8 | 1 |  | 1.75
1.76 | -8 | 1 |  | 1.76
1.77 | -8 | 1 |  | 1.77
1.78 | -8 | 1 |  | 1.78
1.79 | -8 | 1 |  | 1.79
1.8 | -6 | 1 |  | 1.8
1.81 | -6 | 1 |  | 1.81
1.82 | -6 | 1 |  | 1.82
1.83 | -6 | 1 |  | 1.83
1.84 | -6 | 1 |  | 1.84
1.85 | -6 | 1 |  | 1.85
1.86 | -6 | 1 |  | 1.86
1.87 | -6 | 1 |  | 1.87
1.88 | -6 | 1 |  | 1.88
1.89 | -6 | 1 |  | 1.89
1.9 | -5 | 1 |  | 1.9
1.91 | -5 | 1 |  | 1.91
1.92 | -5 | 1 |  | 1.92
1.93 | -5 | 1 |  | 1.93
1.94 | -5 | 1 |  | 1.94
1.95 | -5 | 1 |  | 1.95
1.96 | -5 | 1 |  | 1.96
1.97 | -5 | 1 |  | 1.97
1.98 | -5 | 1 |  | 1.98
1.99 | -5 | 1 |  | 1.99
2 | -5 | 1 |  | 2
2.05 | -5 | 1 |  | 2.05
2.1 | -5 | 1 |  | 2.1
2.15 | -5 | 1 |  | 2.15
2.2 | -5 | 1 |  | 2.2
2.25 | -5 | 1 |  | 2.25
2.3 | -5 | 1 |  | 2.3
2.35 | -5 | 1 |  | 2.35
2.4 | -5 | 1 |  | 2.4
2.45 | -5 | 1 |  | 2.45
2.5 | -5 | 1 |  | 2.5
2.55 | -5 | 1 |  | 2.55
2.6 | -5 | 1 |  | 2.6
2.65 | -5 | 1 |  | 2.65
2.7 | -5 | 1 |  | 2.7
2.75 | -5 | 1 |  | 2.75
2.8 | -4 | 1 |  | 2.8
2.85 | -4 | 1 |  | 2.85
2.9 | -4 | 1 |  | 2.9
2.95 | -4 | 1 |  | 2.95
3 | -4 | 1 |  | 3
3.1 | -4 | 1 |  | 3.1
3.2 | -4 | 1 |  | 3.2
3.3 | -4 | 1 |  | 3.3
3.4 | -4 | 1 |  | 3.4
3.5 | -4 | 1 |  | 3.5
3.6 | -4 | 1 |  | 3.6
3.7 | -4 | 1 |  | 3.7
3.8 | -4 | 1 |  | 3.8
3.9 | -4 | 1 |  | 3.9
4 | -4 | 1 |  | 4
4.1 | -4 | 1 |  | 4.1
4.2 | -4 | 1 |  | 4.2
4.3 | -4 | 1 |  | 4.3
4.4 | -4 | 1 |  | 4.4
4.5 | -4 | 1 |  | 4.5
4.6 | -4 | 1 |  | 4.6
4.7 | -4 | 1 |  | 4.7
4.8 | -4 | 1 |  | 4.8
4.9 | -4 | 1 |  | 4.9
5 | -3 | 1 |  | 5
5.1 | -3 | 1 |  | 5.1
5.2 | -3 | 1 |  | 5.2
5.3 | -3 | 1 |  | 5.3
5.4 | -3 | 1 |  | 5.4
5.5 | -3 | 1 |  | 5.5
5.6 | -3 | 1 |  | 5.6
5.7 | -3 | 1 |  | 5.7
5.8 | -3 | 1 |  | 5.8
5.9 | -3 | 1 |  | 5.9
6 | -3 | 1 |  | 6
6.1 | -2 | 1 |  | 6.1
6.2 | -2 | 1 |  | 6.2
6.3 | -2 | 1 |  | 6.3
6.4 | -2 | 1 |  | 6.4
6.5 | -2 | 1 |  | 6.5
6.6 | -2 | 1 |  | 6.6
6.7 | -2 | 1 |  | 6.7
6.8 | -2 | 1 |  | 6.8
6.9 | -2 | 1 |  | 6.9
7 | -1 | 1 |  | 7
7.1 | -1 | 1 |  | 7.1
7.2 | -1 | 1 |  | 7.2
7.3 | -1 | 1 |  | 7.3
7.4 | -1 | 1 |  | 7.4
7.5 | 0.5 | 2 |  | 7.5
7.6 | 0.5 | 2 |  | 7.6
7.7 | 0.5 | 2 |  | 7.7
7.8 | 0.5 | 2 |  | 7.8
7.9 | 0.5 | 2 |  | 7.9
8 | 0.5 | 2 |  | 8
8.5 | 0.5 | 2 |  | 8.5
9 | 0.5 | 2 |  | 9
9.5 | 0.5 | 2 |  | 9.5
10 | 1 | 3 |  | 10
10.5 | 1 | 3 |  | 10.5
11 | 1 | 3 |  | 11
11.5 | 1 | 3 |  | 11.5
12 | 2 | 3 |  | 12
12.5 | 2 | 3 |  | 12.5
13 | 2 | 3 |  | 13
13.5 | 2 | 3 |  | 13.5
14 | 2 | 4 |  | 14
14.5 | 2 | 4 |  | 14.5
15 | 2 | 4 |  | 15
15.5 | 2 | 4 |  | 15.5
16 | 3 | 4 |  | 16
16.5 | 3 | 4 |  | 16.5
17 | 3 | 4 |  | 17
17.5 | 3 | 4 |  | 17.5
18 | 3 | 5 |  | 18
18.5 | 3 | 5 |  | 18.5
19 | 3 | 5 |  | 19
19.5 | 3 | 5 |  | 19.5
20 | 3 | 5 |  | 20
21 | 3 | 5 |  | 21
22 | 4 | 5 |  | 22
23 | 4 | 5 |  | 23
24 | 4 | 5 |  | 24
25 | 4 | 5 |  | 25
26 | 4 | 6 |  | 26
27 | 4 | 6 |  | 27
28 | 4 | 6 |  | 28
29 | 4 | 6 |  | 29
30 | 4 | 6 |  | 30
31 | 4 | 6 |  | 31
32 | 4 | 6 |  | 32
33 | 4 | 7 |  | 33
34 | 4 | 7 |  | 34
35 | 4 | 7 |  | 35
36 | 4 | 7 |  | 36
37 | 4 | 7 |  | 37
38 | 4 | 7 |  | 38
39 | 4 | 7 |  | 39
40 | 4 | 7 |  | 40
41 | 4 | 7 |  | 41
42 | 4 | 7 |  | 42
43 | 4 | 7 |  | 43
44 | 4 | 7 |  | 44
45 | 4 | 7 |  | 45
46 | 4 | 7 |  | 46
47 | 4 | 7 |  | 47
48 | 4 | 7 |  | 48
49 | 4 | 7 |  | 49
50 | 4 | 8 |  | 50
51 | 4 | 8 |  | 51
52 | 4 | 8 |  | 52
53 | 4 | 8 |  | 53
54 | 4 | 8 |  | 54
55 | 4 | 8 |  | 55
56 | 4 | 8 |  | 56
57 | 4 | 8 |  | 57
58 | 4 | 8 |  | 58
59 | 4 | 8 |  | 59
60 | 4 | 8 |  | 60
61 | 4 | 8 |  | 61
62 | 4 | 8 |  | 62
63 | 4 | 8 |  | 63
64 | 4 | 8 |  | 64
65 | 4 | 8 |  | 65
66 | 4 | 9 |  | 66
67 | 4 | 9 |  | 67
68 | 4 | 9 |  | 68
69 | 4 | 9 |  | 69
70 | 4 | 9 |  | 70
71 | 4 | 9 |  | 71
72 | 4 | 9 |  | 72
73 | 4 | 9 |  | 73
74 | 4 | 9 |  | 74
75 | 4 | 9 |  | 75
76 | 4 | 9 |  | 76
77 | 4 | 9 |  | 77
78 | 4 | 9 |  | 78
79 | 4 | 9 |  | 79
80 | 4 | 10 |  | 80
81 | 4 | 10 |  | 81
82 | 4 | 10 |  | 82
83 | 4 | 10 |  | 83
84 | 4 | 10 |  | 84
85 | 4 | 10 |  | 85
86 | 4 | 10 |  | 86
87 | 4 | 10 |  | 87
88 | 4 | 10 |  | 88
89 | 4 | 10 |  | 89
90 | 4 | 10 |  | 90
91 | 4 | 10 |  | 91
92 | 4 | 10 |  | 92
93 | 4 | 10 |  | 93
94 | 4 | 10 |  | 94
95 | 4 | 10 |  | 95
96 | 4 | 10 |  | 96
97 | 4 | 10 |  | 97
98 | 4 | 10 |  | 98
99 | 4 | 10 |  | 99
100 | 4 | 10 |  | 100
101 | 4 | 10 |  | 101
102 | 4 | 10 |  | 102
103 | 4 | 10 |  | 103
104 | 4 | 10 |  | 104
105 | 4 | 10 |  | 105
106 | 4 | 10 |  | 106
107 | 4 | 10 |  | 107
108 | 4 | 10 |  | 108
109 | 4 | 10 |  | 109
110 | 4 | 10 |  | 110
111 | 4 | 10 |  | 111
112 | 4 | 10 |  | 112
113 | 4 | 10 |  | 113
114 | 4 | 10 |  | 114
115 | 4 | 10 |  | 115
116 | 4 | 10 |  | 116
117 | 4 | 10 |  | 117
118 | 4 | 10 |  | 118
119 | 4 | 10 |  | 119
120 | 4 | 10 |  | 120
121 | 4 | 10 |  | 121
122 | 4 | 10 |  | 122
123 | 4 | 10 |  | 123
124 | 4 | 10 |  | 124