title: How to use IFERROR inside an array formula?
body: <p>If any of the queries in an array formula do not have actual data to query in the range they are hitting they return <code>#VALUE!</code> and mousing over the array formula reveals an error. If I take those queries and wrap them in an IFERROR I get the same results.</p>
  
  <p>If I take what I wrapped in an IFERROR and split it out into its own cell to validate the query it results in displaying the error clause which in this case is a 0.</p>
  
  <p>Here is a <a href="https://docs.google.com/spreadsheets/d/1bsM1VLx-KkDe165CP_owjcfiY2HT-rzZ_9KjwRXIpF8/edit?usp=sharing" rel="nofollow noreferrer">link</a> to an example sheet.</p>
  
  <p>Sheet1 has sample data.<br>
  Sheet2 is intentionally blank to simulate the issue described above.<br>
  Sheet3 has three queries on it in various states. The top two are the array formulas I am attempting to work with. The bottom Query is the IFERROR split out into its own cell to show that the query does in fact work when separated from the rest of the sort(arrayformula(etc)).</p>