title: Excel - Count multiple occurances of a value based on a critera
body: <p>I am trying to count occurances of an account number appearing in column A only when the value in column B = "abc". </p>
  
  <p><code>COUNTIFS(data!G2:N173529,A2)</code> returns the count where the account number appears. However, it returns the complete count without filtering based on column B. How can I add another criteria to further simplify the count based on column B.</p>
  
  <p>UPDATE:
  <code>(COUNTIF($C$2:$C$173529,A2)&gt;1,"Multiple Matches",VLOOKUP(A2,C:M,7,FALSE))</code>
  This returns value from column 7 where A2 value appears once in column C and returns "Multiple Matches" where A2 appears more than once in column C.</p>
  
  <p>However, how do I add the second criteria to check if text "abc" appears in column B.</p>