title: Excel: How to sumif, if the data points share the same row?
body: <p>How can I look up the column header and output the sum of values underneath the two columns but only if they share the same row. For example in my picture I want to sum under A and C which should output 2 since they share a 1 in both the top row and the bottom row. Again if I wanted the same formula for A and B it would output 0 as they share none of the same data points in the same row. Basically I want to pivot not numerical data and be able to  determine the total number of shared x values between my choice of y values.</p>
  
  <p><a href="https://i.stack.imgur.com/WD4GX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WD4GX.png" alt="enter image description here"></a></p>