title: Excel - Using COUNTIFS - Count in Column A if Columns B equals and Columns C equal
body: <p>In ColA I have numbers from 1 to 4</p>
  
  <p>In ColB I have Manager and Non Manager</p>
  
  <p>In ColC I have Locations (London, Glasgow, New York etc.)</p>
  
  <p>I'm trying, in Excel, to count the number of times <code>1</code> appears in ColA when ColB = <code>Manager</code> and ColC equals <code>Glasgow</code>.</p>
  
  <p>I have tried the following but no joy:</p>
  
  <pre><code>=COUNTIFS('Data Sheet'!$A:$A,1,'Data Sheet'!$B:$B,"Manager",'Data Sheet'!$C:$C,"Glasgow")
  </code></pre>
  
  <p>Any help on where I am going wrong would be appreciated.</p>