title: Excel Named range using *? in order to count only relevant cells
body: <p>Would like to use named range in order to find all relevant values in a range. However after several differrent approaches it seems that I cant't progress from here. Using *? in countif formula in order to get all text or values in the range, however it does not count the last cell with a text in the cell for some reason</p>
  
  <pre><code>=OFFSET(DATAMATCH!$I$7;0;0;COUNTIF(DATAMATCH!$I:$I;"*?");1)
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/AUBQ1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AUBQ1.png" alt="enter image description here"></a></p>