title: COUNTIF inside INDIRECT in Google Sheets
body: <p>I am trying to count the number of letter "A" in range E6:AI6 from tab name "FINAL" in different tab name "FINAL DATA"</p>
  
  <p>I basically want to look up <code>'FINAL'!E6:AI6</code>, This is what I have tried:</p>
  
  <pre><code>=COUNTIF(INDIRECT("'FINAL'!E6:AI6" &amp; E6 &amp; ":A" &amp; AI6),1)
  </code></pre>
  
  <p>but it is returning 0 always but in a particular range, there are 5 cells whose value is "A"</p>
  
  <pre><code>=COUNTIF(INDIRECT("'FINAL'!E6:AI6" &amp; E6 &amp; ":A" &amp; AI6),1)
  </code></pre>
  
  <p>It should return 5 instead of 0 cell where I am applying above function</p>