title: EXCEL COUNTIFS Not calculating comparison properly - returns 0
body: <p>Hi I have the following table and am using the COUNTIFS function to calculate the values.</p>
  
  <pre><code>      B    C
  
  6   (0)     (-0.55)
  
  7   (0)     (0.45)
  
  8   (-0.55) (10)
  
  9   (-0.5)  (5)
  
  10  (-0.45) (4)
  
  11  (-0.4)  (3)
  
  12  (-0.35) (5)
  </code></pre>
  
  <p>When I use the following formula the calculation works </p>
  
  <pre><code>=COUNTIFS(B8:B12,"&gt;-55%")
  </code></pre>
  
  <p>When I use the following formula the equation returns 0</p>
  
  <pre><code>=COUNTIFS(B8:B12,"&gt;C6")
  </code></pre>
  
  <p>Can someone explain why this returns 0 and how to fix it?</p>