Thread: Search the number of times 2 corresponding values appear

This is a hard one for me to explain, so I have attached a sample document to better demonstrate this.

I have found out how to search the number of times appears in a column.

{=SUM(IF(ISNUMBER(SEARCH(A15,A1:A6)),1,0))}

What I would like to do is to search the number of times two corresponding values appear within the same row.

In the attached example, I have two columns

COLUMN A(NAME)_________________B1(LETTERS)
Bob________________________________abc
Mary_______________________________abc
Fred_______________________________abc
Bob________________________________def
Mary_______________________________def
Fred_______________________________def



I would like to know the number of times BOB and abc appear in the same row.

In reality, the data appears more like this;

xxxBOBzzz
yyyBOBaaa

so it really needs to be a search string, rather than having the cells being "equal to" the value 'BOB'

I have only read access to the database I am extracting data from, so cannot re-jig the database, but I need to do calculations on the data.

Just to clarify what I'm asking... how do I count the number of times 'BOB' and 'abc' appear in the same row?

Any help would be greatly appreciated.