The expression

ISNUMBER(SEARCH("total",G7))

Will return TRUE if "total" is anywhere in G7. Case insensitive. FIND
is case-sensitive.

HTH
Kostis Vezerides

On Nov 19, 6:31*pm, Tracey wrote:
Hi

I have the following formula but am having some difficulty with the last bit.

If cell G7 contains the word "Total" I want the result to be 0 if the rest
of the criteria is not met.

so if cell G7 = "London Total" I want the result to be 0

=IF(A7="Y",COUNTIF(J7:Q7,"(blank)"),IF(A7="N",10,I F(SEARCH("Total",G7),0,0)))

the rest of the formula works fine...

Many thanks for your help!