Counting Occurrences of Data in Multiple Columns

Hi -

Wondering if anyone has a solution to this problem: we work with a piece of software that does social network analysis, meaning, maps the relationships between organizations within a sector, such as HIV/AIDS advocacy in Tanzania. Reports are then published to a .csv file with multiple organizations listed under multiple types of metrics, tby column. So, my need is to be able to identify, based on a target list of organizations, the number of times each of these organizations appear in multiple columns.

As you can see in the attached excel file, I have been doing this manually by placing a 1 next to each of the target organizations which appear in the lists of interest, and then summing these. Ideally, I would love a generic formula that basically calculates the number of times data found in cell A2 is found in column B2:B50. The formula needs to reference the cell, not "APIWC", as the target organization list changes for each network we map.

Thanks! feel free to comment / ask questions if my problem is unclear.


jacob