title: String value from a cell to access worksheet of same name with a COUNTIF Function?
body: <p>I was looking at this:
  <a href="https://stackoverflow.com/questions/16899175/use-string-value-from-a-cell-to-access-worksheet-of-same-name?rq=1">Use string value from a cell to access worksheet of same name</a></p>
  
  <p>But I want to know how to do that with a CountIF function. 
  My WorkSheets are named by the Codes in column A3-A12, and that could increase in time.</p>
  
  <pre><code>=COUNTIF('100'!H:H,$B$2)
  </code></pre>
  
  <p>is how I'm counting all records on Worksheet 100 with the same value as in B2 (it's a date).</p>
  
  <p>How do I use =INDIRECT and CountIF together? something like, </p>
  
  <p><code>=INDIRECT(COUNTIF("'"&amp;A4&amp;"'!H:H,$B$2))</code></p>
  
  <p>That doesn't work, but hopefully you understand what I wish to do. </p>
  
  <p>I'm not calculating this function on each worksheet, then using Indirect to grab the values, because everyday those worksheets are blanked. So the functions wouldn't stay as well.
  But that might be what I have to do, unless I can think of a macro. </p>
  
  <p>Thanks!</p>