title: Survey data - sum of column based on criteria of multiple columns and rows
body: <p>I have an extremely complex (well it is to me) question that I am hoping someone can assist me with. I'll go through the scenario. 
  I am trying to gather data by surveying some people.  Each question links to a particular category (where I've allocated it either <code>a +1</code> or <code>a -1</code> score to determine characteristics depending on whether the person agrees or disagrees with the statement). </p>
  
  <p>e.g referring to the Sample Table below if they select "agree" to Question 1 they will get <code>a +1</code> score for <code>CAT7 (Category 7)</code>.  If they Agree with Question 5, they get <code>a -1</code> for <code>CAT4</code> and <code>a +1</code> for <code>CAT8</code>.  </p>
  
  <p>I have tried <code>SUMPRODUCTS, INDEX, MATCH, VLOOKUPS, COUNTIFS</code> - I could be missing something. Might have to go some VBA code? If anyone can help.  </p>
  
  <p>I basically want scores for each category </p>
  
  <p>Please help! It's much appreciated! </p>
  
  <p><img src="https://i.stack.imgur.com/F8Uo4.jpg" alt="Sample Table"></p>