Peter, I have done as you told me and it works. I have a last question that concerns this matter: what if I have to select multiple ranges in Countif? in my real sheets I have ranges A13:AZ13 and J17:AX17 and G26:S26 and AE26:AN26. I know that countif cannot handle multiple ranges and I have tried with +countif but it doesn't work