title: using both QUERY and FILTER together in a single statement?
body: <p>I hope someone can help me; I am building some spreadsheets to help with time-tracking. I have a list of tasks, with columns for criteria including date, hours spent, category of work, and client.</p>
  
  <p>I want to filter this data by month, so for example I would like to know how long I spent in a single month on correspondence. This means I need to select all the rows where category = 'correspondence' and where the dates are all from one specified month. At the moment, I am having to use a query which outputs to an intermediary table, and then run a filter function on that table in order to output to my final table. Here are my two functions:</p>
  
  <pre><code>=QUERY( 'Task List'!A4:F , "select A, B, E, F where C = 'Correspondence'" )
  </code></pre>
  
  <p>that gives me the first table, with just the rows where the category is "Correspondence". Then, on that table, I have to run the next function:</p>
  
  <pre><code>=filter(J4:M,J4:J&gt;=date(2015,4,1),J4:J&lt;=date(2015,4,31))
  </code></pre>
  
  <p>To get only the rows from this month of April. If possible I would like to remove the intermediary table (which serves no other purpose and just clutters my sheet).</p>
  
  <p>Is it possible to combine these statements and do the process in one step?</p>
  
  <p>Thanks.</p>