Excel - Count multiple occurances of a value based on a critera
<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>