title: COUNTIF relative reference
body: <p>Should just be an easy solution, but I need your help.</p>
  
  <p>I have a number of columns of information and I want to summarise them. I'll draw an example below:</p>
  
  <pre><code>row    a             b             c             d            e
  1      Question no.  subject area  Answer no.    STUDENT 1    STUDENT 2
  2      1             maths         A             A            A
  3      2             maths         D             D            B
  4      3             science       C             A            C
  5      4             maths         A             A            A
  </code></pre>
  
  <p>What is the best formula to use to 'count' 1 for each response that each student gets right. I want to create a countif formula (maybe this isn't the best one) to work out if their score in column D or E, equals the value in column C, and be able to split this up for subject matter.</p>
  
  <pre><code>=COUNTIFS( b2:b5, "maths"   ,    d2:d5 , c2:c5=ds:d5  )
  </code></pre>
  
  <p>The first bit of the formula works (identifying how many 'maths' questions. </p>
  
  <p>My problem is that I can't get (or work out) how to count=1 when each student score equals the relative value in column C.</p>
  
  <p>Any thoughts?</p>