title: In Excel, add 1 if not number, or else add the number
body: <p>In <a href="/questions/tagged/excel" class="post-tag" title="show questions tagged 'excel'" rel="tag">excel</a>, how do I write a formula that does the following:</p>
  
  <p>In a certain cell range, if the cell contains a non-numeric entry, add one, or else add the number the cell contains.</p>
  
  <p>for example</p>
  
  <blockquote>
    <p>4<br>
      xyz<br>
      def<br>
      bc<br>
      2<br>
      0  </p>
  </blockquote>
  
  <p><code>=9</code></p>
  
  <p>or </p>
  
  <blockquote>
    <p>1<br>
      ab<br>
      cd<br>
      2<br>
      af  </p>
  </blockquote>
  
  <p>=6 </p>