sure. just add the
a1:a10<0 parameter
=SUMPRODUCT((LEN(TRIM(A1:A10))<7)*(a1:a10<))

--
Don Guillett
SalesAid Software

"cottage6" wrote in message
...
Thanks to both Peo and Don whose formulas solved my problem. One
additional
question; can I leave blank cells out of the count?

"Peo Sjoblom" wrote:

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?