title: AVERAGEIF(range, criteria) formula that ignores errors in the data
body: <p>How do you specify the criteria if you want to average a range of numbers but want to ignore errors using the AVERAGEIF() function?</p>
  
  <p>For example, given the data below:</p>
  
  <pre><code>A1: 1
  A2: #DIV/0!
  A3: #VALUE!
  A4: 5
  A5: 0
  </code></pre>
  
  <p>I want to use the AVERAGEIF(range, criteria) formula something like this:</p>
  
  <pre><code>=AVERAGEIF(a1:a5,and("&lt;&gt;#DIV/0!","&lt;&gt;#VALUE!"))
                      or
  =AVERAGEIF(a1:a5,"&lt;&gt;Error()")
  </code></pre>
  
  <p>Is there a way to specify a criteria to exclude errors?  The answer I expect from the range is 2, the average of the three valid numbers (1, 5, &amp; 0).</p>
  
  <p>I found, via searches, that there is a way to do this using an array formula or other functions, but I want to find out if there is a way to do this without an array formula or using another function.  Basically, can you specify in the criteria to ignore errors.  For example, I can ignore one error like this:</p>
  
  <pre><code>AVERAGEIF(a1:a5,"&lt;&gt;#DIV/0!")
  </code></pre>
  
  <p>But I don't know how to specify to ignore any errors.  So my question is a criteria question.  I'm using Microsoft Excel 2013.</p>