Hi,

I have a column with text in it. Can I look for specific words in a string
of text in any cell in that range. The cell will not equal the word because
there is a string of text. I need to add up numbers in the next column if
the cell contains the specific word. So basically....If any cell in
B25:B500 contains "the specified word" then sum the number in column C next
to where it is found.

Thanks.

This will sum K1:K5 where J1:J5 contain the string "AB" - not case sensitive

=SUMIF(J1:J5,"=*AB*",K1:K5)

HTH

"Dan B" wrote:

Hi,

I have a column with text in it. Can I look for specific words in a string
of text in any cell in that range. The cell will not equal the word because
there is a string of text. I need to add up numbers in the next column if
the cell contains the specific word. So basically....If any cell in
B25:B500 contains "the specified word" then sum the number in column C next
to where it is found.

Thanks.

perfect. Thanks.


"Toppers" wrote in message
...
This will sum K1:K5 where J1:J5 contain the string "AB" - not case
sensitive

=SUMIF(J1:J5,"=*AB*",K1:K5)

HTH

"Dan B" wrote:

Hi,

I have a column with text in it. Can I look for specific words in a
string
of text in any cell in that range. The cell will not equal the word
because
there is a string of text. I need to add up numbers in the next column
if
the cell contains the specific word. So basically....If any cell in
B25:B500 contains "the specified word" then sum the number in column C
next
to where it is found.

Thanks.