Is this type of lookup possible?...
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.
|