count if the cell contains a word found in another cell

  • Thread starter Thread starter Go Bucks!!!
  • Start date Start date
G

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
 
Hi Rag,

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