title: Creating Summary table using countif and lookup
body: <p>I've had a bit of a mind blank with this so out of desperation I'm asking for your help.</p>
  
  <p>I have the following set of data in Excel:</p>
  
  <pre><code>DE     | COMPLETE
  FR     | NOT STARTED
  UK/INT | NOT STARTED
  DE     | COMPLETE
  FR     | NOT STARTED
  UK/INT | NOT STARTED
  DE     | FAIL
  FR     | NOT STARTED
  UK/INT | NOT STARTED
  </code></pre>
  
  <p>The statuses will change depending on my project progress so I want to create an automated summary to count the statuses in the following table:</p>
  
  <pre><code>Territory | Fail | Not Started | Complete
  France    |  0   |     3       |    0
  Germany   |  1   |     0       |    2 
  UK / Int  |  0   |     3       |    0
  </code></pre>
  
  <p>I know that it would be easier if I sort the table and create ranges for France, Germany and UK/INT then do a countif but i need to keep the format as it is.</p>
  
  <p>How do I combine the lookup of the country with the count of the statuses?</p>
  
  <p>Cheers!</p>