title: COUNTIF range exclude header
body: <pre><code>=COUNTIF('sheet'!A:A, "*Pdf*")
  </code></pre>
  
  <p>This formula gives me no problem in general, but because the word pdf is part of the header cell, it gives me a wrong value from what I am actually trying to count (the actual data)</p>
  
  <p>Some people have suggested that I select the range by doing shift+ctrl+down arrow, and it seems to work seamlessly for sum formula, (as in if I add in more values under the said range, it automatically adjusts the value) but when it is with countif, using that solution will not include any new data input.</p>
  
  <p>The whole reason I want to have the range be the whole row is so that when new data gets added, the formula will automatically adjust itself.</p>
  
  <p>So ultimately what I am trying to do is have the whole row selected as a range, except for the header cell (which in this case would be A1) Changing A:A to A2:A didn't work either.</p>