SUMPRODUCT, COUNTIF formulas not correctly counting based on two sets of criteria

I've attached an Excel file to this post. For some reason, I can't find the right formula (i.e. I've tried SUMPRODUCT, COUNTIF, and other combinations) to correctly account the number of instances of a value appearing, based on satisfying two sets of criteria indexed in other columns. I'm thinking it's just a minor tweak of something that I missed. The attached file provides a lookup table, several of my attempts to solving the problem, and a restatement of my question with desired results versus actual results. Any help would be much appreciated.

Is this what you want?

=COUNTIF($C$3:$C$15,G3)

Another way......

Please Login or Register  to view this content.

I think the correct one will be like this.......

Please Login or Register  to view this content.

close but the first 2 should be
=SUMPRODUCT(--($B:$B=$B$3),--($C:$C=$C$5))
=COUNTIFS($B:$B,$B$3,$C:$C,$C$5)
or
more usable
=SUMPRODUCT(--($B:$B="MCA"),--($C:$C="ACCOUNT MANAGER"))
=COUNTIFS($B:$B,"MCA",$C:$C,"ACCOUNT MANAGER")