title: Ignore specific symbol in cells before calculating the average of the column
body: <p>I have a column of data in <code>B7:B30</code>:</p>
  
  <pre><code>&lt;0.0012
  &lt;0.0013
  &lt;0.0014
  &lt;0.0015
  </code></pre>
  
  <p>And so on...</p>
  
  <p>I want the average of these cells to appear in cell <code>B31</code>. But Excel sees the <code>&lt;</code> symbol in each cell and won't return a value. I need the lesser than symbol to remain in each cell. </p>
  
  <p>Is this possible?</p>