Spreadsheet: 879062d1726498781-countif-is-missing-a-numeric-value-toforumcountif
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Points | Value | Occurance | "L" rounded
 |  |  |  |  |  |  |  |  |  |  | -0.01
 |  |  |  |  |  |  |  |  |  |  | -0.02
 |  |  |  |  |  |  |  |  |  |  | -0.03
 |  |  |  |  |  |  |  |  |  |  | -0.04
 |  |  |  |  |  |  |  |  |  |  | -0.05
 |  |  |  |  |  |  |  |  |  |  | -0.06
 |  |  |  |  |  |  |  |  |  |  | -0.07
 |  |  |  |  |  |  |  |  |  |  | -0.08
 |  |  |  |  |  |  |  |  |  |  | -0.09
 |  |  |  |  |  |  |  |  |  |  | -0.1
 |  |  |  |  |  |  |  |  |  |  | -0.11
 |  |  |  |  |  |  |  |  |  |  | -0.12
 |  |  |  |  |  |  |  |  |  |  | -0.13
 |  |  |  |  |  |  |  |  |  |  | -0.14
 |  |  |  |  |  |  |  |  |  |  | -0.15
 |  |  |  |  |  |  |  |  |  |  | -0.16
 |  |  |  |  |  |  |  |  |  |  | -0.17
 |  |  |  |  |  |  |  |  |  |  | -0.18
 |  |  |  |  |  |  |  |  |  |  | -0.19
 |  |  |  |  |  |  |  |  |  |  | -0.2
 |  |  |  |  |  |  |  |  |  |  | -0.21
 |  |  |  |  |  |  |  |  |  |  | -0.22
 |  |  |  |  |  |  |  |  |  |  | -0.23
 |  |  |  |  |  |  |  |  |  |  | -0.24
 |  |  |  |  |  |  |  |  |  |  | -0.25
 |  |  |  |  |  |  |  |  |  |  | -0.26
 |  |  |  |  |  |  |  |  |  |  | -0.27
 |  |  |  |  |  |  |  |  |  |  | -0.28
 |  |  |  |  |  |  |  |  |  |  | -0.29
 |  |  |  |  |  |  |  |  |  |  | -0.3
 |  |  |  |  |  |  |  |  |  |  | -0.31
 |  |  |  |  |  |  |  |  |  |  | -0.32
 |  |  |  |  |  |  |  |  |  |  | -0.33
 |  |  |  |  |  |  |  |  |  |  | -0.34
 |  |  |  |  |  |  |  |  |  |  | -0.35
 |  |  |  |  |  |  |  |  |  |  | -0.36
 |  |  |  |  |  |  |  |  |  |  | -0.37
 |  |  |  |  |  |  |  |  |  |  | -0.38
 |  |  |  |  |  |  |  |  |  |  | -0.39
 |  |  |  |  |  |  |  |  |  |  | -0.4
 |  |  |  |  |  |  |  |  |  |  | -0.41
 |  |  |  |  |  |  |  |  |  |  | -0.42
 |  |  |  |  |  |  |  |  |  |  | -0.43
 |  |  |  |  |  |  |  |  |  |  | -0.44
 |  |  |  |  |  |  |  |  |  |  | -0.45
 |  |  |  |  |  |  |  |  |  |  | -0.46
 |  |  |  |  |  |  |  |  |  |  | -0.47
 |  |  |  |  |  |  |  |  |  |  | -0.48
 |  |  |  |  |  |  |  |  |  |  | -0.49
 |  |  |  |  |  |  |  |  |  |  | -0.5
 |  |  |  |  |  |  |  |  |  | -1.170000000000002 | -0.51
 |  |  |  |  |  |  |  |  |  |  | -0.52
 |  |  |  |  |  |  |  |  |  |  | -0.53
 |  |  |  |  |  |  |  |  |  |  | -0.54
 |  |  |  |  |  |  |  |  |  |  | -0.55
 |  |  |  |  |  |  |  |  |  |  | -0.56
 |  |  |  |  |  |  |  |  |  |  | -0.57
 |  |  |  |  |  |  |  |  |  |  | -0.58
 |  |  |  |  |  |  |  |  |  |  | -0.59
 |  |  |  |  |  |  |  |  |  |  | -0.6
 |  |  |  |  |  |  |  |  |  |  | -0.61
 |  |  |  |  |  |  |  |  |  |  | -0.619999999999999
 |  |  |  |  |  |  |  |  |  |  | -0.629999999999999
 |  |  |  |  |  |  |  |  |  |  | -0.639999999999999
 |  |  |  |  |  |  |  |  |  |  | -0.649999999999999
 |  |  |  |  |  |  |  |  |  |  | -0.659999999999999
 |  |  |  |  |  |  |  |  |  |  | -0.669999999999999
 |  |  |  |  |  |  |  |  |  |  | -0.679999999999999
 |  |  |  |  |  |  |  |  |  |  | -0.689999999999999
 |  |  |  |  |  |  |  |  |  |  | -0.699999999999999
 |  |  |  |  |  |  |  |  |  |  | -0.709999999999998
 |  |  |  |  |  |  |  |  |  |  | -0.719999999999998
 |  |  |  |  |  |  |  |  |  |  | -0.729999999999998
 |  |  |  |  |  |  |  |  |  |  | -0.739999999999998
 |  |  |  |  |  |  |  |  |  |  | -0.749999999999998
 |  |  |  |  |  |  |  |  |  |  | -0.759999999999998
 |  |  |  |  |  |  |  |  |  |  | -0.769999999999998
 |  |  |  |  |  |  |  |  |  |  | -0.779999999999998
 |  |  |  |  |  |  |  |  |  |  | -0.789999999999998
 |  |  |  |  |  |  |  |  |  |  | -0.799999999999998
 |  |  |  |  |  |  |  |  |  |  | -0.809999999999997
 |  |  |  |  |  |  |  |  |  |  | -0.819999999999997
 |  |  |  |  |  |  |  |  |  |  | -0.829999999999997
 |  |  |  |  |  |  |  |  |  |  | -0.839999999999997
 |  |  |  |  |  |  |  |  |  |  | -0.849999999999997
 |  |  |  |  |  |  |  |  |  |  | -0.859999999999997
 |  |  |  |  |  |  |  |  |  |  | -0.869999999999997
 |  |  |  |  |  |  |  |  |  |  | -0.879999999999997
 |  |  |  |  |  |  |  |  |  |  | -0.889999999999997
 |  |  |  |  |  |  |  |  |  |  | -0.899999999999997
 |  |  |  |  |  |  |  |  |  |  | -0.909999999999996
 |  |  |  |  |  |  |  |  |  |  | -0.919999999999996
 |  |  |  |  |  |  |  |  |  |  | -0.929999999999996
 |  |  |  |  |  |  |  |  |  |  | -0.939999999999996
 |  |  |  |  |  |  |  |  |  |  | -0.949999999999996
 |  |  |  |  |  |  |  |  |  |  | -0.959999999999996
 |  |  |  |  |  |  |  |  |  |  | -0.969999999999996
 |  |  |  |  |  |  |  |  |  |  | -0.979999999999996
 |  |  |  |  |  |  |  |  |  |  | -0.989999999999996
 |  |  |  |  |  |  |  |  |  |  | -0.999999999999996
 |  |  |  |  |  |  |  |  |  |  | -1.01
 |  |  |  |  |  |  |  |  |  |  | -1.02
 |  |  |  |  |  |  |  |  |  |  | -1.02999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.04
 |  |  |  |  |  |  |  |  |  |  | -1.04999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.06
 |  |  |  |  |  |  |  |  |  |  | -1.06999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.08
 |  |  |  |  |  |  |  |  |  |  | -1.08999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.09999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.10999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.11999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.12999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.13999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.14999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.15999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.16999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.17999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.18999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.19999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.20999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.21999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.22999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.23999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.24999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.25999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.26999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.27999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.28999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.29999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.30999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.31999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.32999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.33999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.34999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.35999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.36999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.37999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.38999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.39999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.40999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.41999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.42999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.43999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.44999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.45999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.46999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.47999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.48999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.49999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.50999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.51999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.52999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.53999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.54999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.55999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.56999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.57999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.58999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.59999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.60999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.61999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.62999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.63999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.64999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.65999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.66999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.67999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.68999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.69999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.70999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.71999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.72999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.73999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.74999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.75999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.76999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.77999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.78999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.79999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.80999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.81999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.82999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.83999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.84999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.85999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.86999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.87999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.88999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.89999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.90999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.91999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.92999999999999
 |  |  |  |  |  |  |  |  |  |  | -1.93999999999999