title: Calculate the COUNTIFS criteria range dynamically
body: <p>I have a excel formula as below,</p>
  
  <pre><code>COUNTIFS($A$8:$A$14,$A8,$B$8:$B$14,$B8)
  </code></pre>
  
  <p>Here I want the criteria range to be calculated with a simple logic.</p>
  
  <p>Instead of <code>$A$14</code> I want this value to be calculated A$8+4 i.e. $A$14</p>
  
  <p>In other words, it should get the current row and add 4 to be the criteria range for COUNTIFS</p>
  
  <p>How can this be done is excel within the COUNTIFS formula?</p>
  
  <p>Cheers</p>