Try

=SUMPRODUCT(--(LEN(TRIM(A1:A10))<7))


Regards,

Peo Sjoblom


"cottage6" wrote:

I want to count the number of cells in a column that do not have a value that
is 7 digits in length. I've tried several combinations of CountIf and Len
and have failed miserably! Can anyone help?