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