title: Excel's COUNTIF doesn't work
body: <p>I'm at my wits end trying to troubleshoot COUNTIF</p>
  
  <p><img src="https://i.stack.imgur.com/Qguy7.jpg" alt="enter image description here"></p>
  
  <p>I see there are three instances of 11.0.6000.0162 but =COUNTIF(A1:A8559,B1) doesn't believe this.</p>
  
  <p>And I evaluated the cells</p>
  
  <p>=A1=B7 = TRUE</p>
  
  <p>=A2=B7 = TRUE</p>
  
  <p>=A5=B7 = TRUE</p>
  
  <p>I have been trying to run larger figures and now I know why the numbers don't quite add up .... Thanks!</p>
  
  <p>UPDATE</p>
  
  <p>Here is new set of data. I thought =COUNTIF($A$1:$A$20,B1) would work, but I'm still having problems</p>
  
  <p><img src="https://i.stack.imgur.com/P9RKb.jpg" alt="enter image description here"></p>