Using COUNTIFS with 2 criteria on 2 different sized ranges?
<p>For my current research I want to return a count of a value (A, B or C) listed in column AO, when a criteria in a differently sized range (T:Y) is met. The criteria is that it simply has to be a specific word (lets say "Jack", "Tony" and "Bobby")</p>

<p>Example:</p>

<p><img src="https://i.stack.imgur.com/fsvFk.png" alt="enter image description here"></p>

<p>I would for instance like to know all the A, B &amp; C's for all the Jacks (in this case 2, 0, 1) but i can't seem to use the countifs formula as it requires the ranges of both criteria to be the same?</p>