title: COUNTIF showing inconsistent behavior
body: <p>I'm using the following formula to find a value in the 'CDS et al' spreadsheet:</p>
  
  <p>=COUNTIF(A3,'CDS et al'!<strong>A:A</strong>)</p>
  
  <p>It returns <strong>0</strong>, which is incorrect because I know the value shows up in the A column once. However, when I find the cell it's in manually and enter that into the countif formula, it finds it:</p>
  
  <p>=COUNTIF(A3,'CDS et al'!<strong>A2</strong>)</p>
  
  <p>The value is <strong>1</strong>. What gives? A2 is a subset of A:A! A:A should return 1 as well. </p>