try
=SUMPRODUCT((LEN(A2:A22)<7)*1)

--
Don Guillett
SalesAid Software

"cottage6" wrote in message
...
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?