title: FILTER range must be a single row or a single column. when trying to apply a condition across several columns at once
body: <p>Here is a regular filter function that works as expected:</p>
  <pre><code>=filter(
  data!$A$2:$A,
  date!$D$2:$D&gt;=$A$16,
  data!$D$2:$D&lt;=$B$16,
  data!$EC$2:$EC=$A23
  )
  </code></pre>
  <p>This returns the subset of values in <code>data!$A$2:$A</code> that match the conditions. Great.</p>
  <p>I would like to add a condition to a range of columns, that all that <code>data!$CD$2:$CN</code> are all equal to one. Tried:</p>
  <pre><code>=filter(
  data!$A$2:$A,
  date!$D$2:$D&gt;=$A$16,
  data!$D$2:$D&lt;=$B$16,
  data!$EC$2:$EC=$A23,
  data!$CD$2:$CN=1
  )
  </code></pre>
  <p>Then tried:</p>
  <pre><code>=filter(
  data!$A$2:$A,
  date!$D$2:$D&gt;=$A$16,
  data!$D$2:$D&lt;=$B$16,
  data!$EC$2:$EC=$A23,
  sum(data!$CD$2:$CN)=11 # there's 11 columns in this range
  )
  </code></pre>
  <p>I get the error above. I could manually add a condition for each of the 11 columns:</p>
  <pre><code>=filter(
  data!$A$2:$A,
  date!$D$2:$D&gt;=$A$16,
  data!$D$2:$D&lt;=$B$16,
  data!$EC$2:$EC=$A23,
  data!$CD$2:$CD=1,
  data!$CE$2:$CE=1,
  ... lost more in here all the way to ...
  data!$CN$2:$CN=1
  )
  </code></pre>
  <p>But that's going to get pretty repetitive.</p>
  <p>Is there a way to filter across a range of columns, in this case I want to filter to only include rows where everything in <code>data!$CD$2:$CN</code> equals 1?</p>