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

There's a logic "problem" with your formula.

If the first 2 IFs are false then the last IF returns 0 whether G7 contains
"total" or not.


--
Biff
Microsoft Excel MVP


"Tracey" wrote in message
...
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!