title: COUNTIF and IMPORTRANGE returning 0
body: <p>I would like to use the COUNTIF and IMPORTRANGE functions in Google Sheets, but the results keep returning 0. Here's my formula:</p>
  
  <pre><code>=COUNTIF(IMPORTRANGE("sheet key","PDFs!A2:A13"), "Yes")
  </code></pre>
  
  <p>There are no permission restrictions on the sheet I am trying to query, though I might restrict it to specific people.</p>
  
  <p>I've tried the formula using the key and the sheet URL.</p>
  
  <p>I've tested the formula with a tab in the same sheet and it works. Here is the formula I used:</p>
  
  <pre><code> =COUNTIF(PDFs!A2:A13,"Yes")
  </code></pre>
  
  <p>Any thoughts on why the COUNTIF/IMPORTRANGE formula isn't working?</p>
  
  <p>Would restricting permissions make the formula not work?</p>