count if the cell contains a word found in another cell
 

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

count if the cell contains a word found in another cell
 

try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Go Bucks!!!" wrote in message
...
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

count if the cell contains a word found in another cell
 

Hi Rag,

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



"RagDyer" wrote:

try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Go Bucks!!!" wrote in message
...
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