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
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