count if the cell contains a word found in another cell

[Go Bucks!!!]

I am trying to count the 1's found in column B, if column A contains a word
found in cell A1

A B
1 Austin 1
2 IBM 2
3 Micron 1
4 National 1
5 Samsung 1

11 Austin Semiconductor 1
12 IBM 1
13 IBM 1
14 IBM 0
15 National Semiconductor 1
16 Samsung 1
17 Micron Semiconductor 1
18 Micron Semiconductor 0

 

[RagDyer]

try this:

=SUMPRODUCT((ISNUMBER(SEARCH("austin",A1:A20)))*(B1:B20=1))

 

[Go Bucks!!!]

Hi Rag,

I wasnt clear on this. I will repost with a better subject and
explanation/example. Thanks,