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!