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?