title: Dynamic range in excel: How to remove Counta counting blank cells(made blank by ifferror formulas)
body: <p>I have to plot a data in chart which I have made dynamic by using a named range using offset, counta(for required rows) in the chart area.</p>
  
  <p>The problem with using counta is it counts the rows which has blank cells(made blank by iferror formula),which I do not want.Moreover I cannot remove those formulas 'coz when the data is there that has to be dynamically present in the chart.</p>
  
  <pre><code>OFFSET('ABC'!$T$2,1,0,COUNTA('ABC'!$T2:$T1000),4)
  </code></pre>
  
  <p>Here; let us say the values are there for 10 rows;but the formulas are till 15 so how do I stop counta from counting the 5 rows(which have been made blank by iferror).</p>