Hi,

Validation using the keys : CTRL + Maj + Enter

=Sum(if(len(Your_Range)=2;1))



"John" a écrit dans le message de groupe de discussion :
...
vba excel 07
Want to count all strings that are two characters long in a range. Using
countif(range, "??") but it doesn't work.

The strings are numbers so I think that might be screwing it up. Tried
countif(range,"<100") but that didn't work either.

John