Using this:

=SUMPRODUCT(--(ISNUMBER(MATCH(C6:C22,A3:A7,0))))
Will count the number of occurrences in C6:C22 based on text matches in the range A3:A7 (in this case, it is 6). I'm not sure what else you require, since your sample workbook seems to be disjointed.