Search and count matching values in each column

Hello,

This post relates somewhat to a post I have created a little while ago here:

http://www.excelforum.com/excel-prog...er-column.html

which has been solved.

I would like to search for values in each column, and count the matching results with another value. The end result is the total match found between all columns.

I am attaching an example workbook. If anyone could help it would be amazing. If I am not being clear in any way please let me know.

Thank you