title: Array arguments countifs are of different size - Google sheets
body: <p>I've seen another post about this already but it wont fix my issue. For a research I easily want to create an overview of the data with Google Sheets. At this moment I get a #VALUE error when I use a <code>COUNTIFS</code> function.</p>
  <p><a href="https://docs.google.com/spreadsheets/d/157T-HulQ9REw3jh1fL2O1SfatXg8MgIJrq3cdkA9ZQk/edit?usp=sharing" rel="nofollow noreferrer">Link to spreadsheet</a></p>
  <p>In sheet1 (Data) you can find the research data.<br />
  In sheet2 (Overview) I want to make the overview of the data.<br />
  In this case every row is the data of one respondent.<br />
  They were able to cross multiple answers at a question about the type of holidays they took in the last two years.<br />
  In column <code>G:K</code> the answers can be found.</p>
  <p>I want to create an overview where I can see how many times people from different ages answered a specific question.</p>
  <p>I use the formula:</p>
  <pre><code>=COUNTIFS(Data!$D$2:$D$7, $A2, Data!$I$2:$N, B$1)
  </code></pre>
  <p><a href="https://i.stack.imgur.com/KCUDG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KCUDG.png" alt="Spreadsheet example" /></a></p>
  <p>Hope that anyone is able to help me. Thanks!</p>