[Sorry about the bogus first posting. Fat fingers, I guess.]

"Go Bucks!!!" wrote:
I tried using this wild card in a sumproduct, but it isnt working.
[....]
=sumproduct(((E:E=$D9)*(B:B="*CPB*"))

What revision of Excel are you using? I know that E:E and B:B do not work
in Excel 2003. I don't know about Excel 2007.

Anyway, you cannot use wildcards in simple comparisons. You can use SEARCH
or FIND. Use FIND if you want the comparison to be case-sensitive.

=sumproduct( (E1:E100=$D9) * (iserror( find("CPB",B1:B100) )=false) )


----- original message -----

"Go Bucks!!!" wrote in message
...
I tried using this wild card in a sumproduct, but it isnt working.

My forumula is:

=sumproduct(((E:E=$D9)*(B:B="*CPB*"))

Do I need to do something differently for sumproducts?

Thanks,



"Jacob Skaria" wrote:

If this is one cell
try
=IF(COUNTIF(A1,"*check*"),"Checking","Doing")

Since you mentioned row...try the below as well It checks for these words
in
Cols A to J for the first row. Copy down as required.
=IF(COUNTIF(A1:J1,"*check*"),"Checking","Doing")

If this post helps click Yes
---------------
Jacob Skaria


"Eán" wrote:

I have a row containing various text including the words 'Check' &
'Checking'; in a separate row I would like to identify all the cells
which
include 'Check' or 'Checking' and return the text "Checking" if it
contains
either 'Check' or 'Checking' or "Doing" if it doesn't.
Hope this makes sense?
Many thanks