count if the cell contains a word found in another cell

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
 
G

Go Bucks!!!

Hi Rag,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top