Why is my nested countif loop wrong

Hi all

I have this code :

Please Login or Register  to view this content.

what it should do :

look if (Cells(21 + i, 31) exists in range ( ai:ai) ( i opted to do a countif , either its found so count is > 0 or not) -- if count > 0 then it should put value " 55 " in the cells if count < 0 then simply show the counted value

somehow it always skips the first part of the if/ else condition and always applies the second part..



dont understand why

oh boy

im not sure i understand why this works , but it did

thanks a million... i will investigate to find out the logic