title: QUERY formula returns #N/A error “Query completed with an empty output.”
body: <p>sample sheet - <a href="https://docs.google.com/spreadsheets/d/1RPpwHAtER05h7-K1Hxku4lz33kBI4KnL7kzJa63YuvY/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1RPpwHAtER05h7-K1Hxku4lz33kBI4KnL7kzJa63YuvY/edit?usp=sharing</a></p>
  <p>Having issues with using =query() in cell A10 on a column that has data with dates and texts ('raw A'!A). Any idea how do I go about this? Data in &quot;raw A&quot; and raw B&quot; tab would not be editable or changeable.</p>
  <p><code>=QUERY('raw A'!A:M,&quot;SELECT A,E,F,G,H,I,J,K,L,M WHERE A CONTAINS 'summary' AND not C CONTAINS 'ALL'&quot;,0)</code></p>
  <p>The idea is to allow users to import raw data sheets into this template sheet and have the &quot;result&quot; tab auto retrieve the filtered data and display it in a refined layout.</p>