title: Average not working with indirect formula and blank values
body: <p>I have this formula:</p>
  
  <pre><code>=IFERROR(
  (
  (
  IFERROR(INDIRECT($A6&amp;"!$E$15");"")
  +IFERROR(INDIRECT($A6&amp;"!$E$29");"")
  +IFERROR(INDIRECT($A6&amp;"!$E$43");"")
  +IFERROR(INDIRECT($A6&amp;"!$E$57");"")
  +IFERROR(INDIRECT($A6&amp;"!$E$71");"")
  +IFERROR(INDIRECT($A6&amp;"!$E$84");"")
  )
  /6);"")
  </code></pre>
  
  <p>When any of these IDIRECTS return a blank value, I get an #VALUE! error (without the first IFERROR). Each individual line works just fine, and when putting them in cells individually, I can average them fine. If I remove the /6 part of this formula however, and wrap the lines with an AVERAGE-formula, I get the #VALUE! error also.</p>
  
  <p>How can I proceed? </p>
  
  <p><strong>EDIT, SOLUTION FOUND (Thanks Mrig)</strong>:</p>
  
  <pre><code>=IFERROR(
  (
  (
  IF(ISNUMBER(INDIRECT($A7&amp;"!$E$15"));INDIRECT($A7&amp;"!$E$15");0)
  +IF(ISNUMBER(INDIRECT($A7&amp;"!$E$29"));INDIRECT($A7&amp;"!$E$29");0)
  +IF(ISNUMBER(INDIRECT($A7&amp;"!$E$43"));INDIRECT($A7&amp;"!$E$43");0)
  +IF(ISNUMBER(INDIRECT($A7&amp;"!$E$57"));INDIRECT($A7&amp;"!$E$57");0)
  +IF(ISNUMBER(INDIRECT($A7&amp;"!$E$71"));INDIRECT($A7&amp;"!$E$71");0)
  +IF(ISNUMBER(INDIRECT($A7&amp;"!$E$84"));INDIRECT($A7&amp;"!$E$84");0)
  )/
  (
  COUNTIF(INDIRECT($A7&amp;"!$E$15");"&gt;=0")
  +COUNTIF(INDIRECT($A7&amp;"!$E$29");"&gt;=0")
  +COUNTIF(INDIRECT($A7&amp;"!$E$43");"&gt;=0")
  +COUNTIF(INDIRECT($A7&amp;"!$E$57");"&gt;=0")
  +COUNTIF(INDIRECT($A7&amp;"!$E$71");"&gt;=0")
  +COUNTIF(INDIRECT($A7&amp;"!$E$82");"&gt;=0")
  )
  );"")
  </code></pre>
  
  <p>The COUNTIF's bascially replaces the number "6" in the original code, and checks which of the INSNUMER's (instead of IFERROR's) that isn't blanks, so anything that's 0% or higher (actual value) will be counted, to get to the true average. </p>