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

--
Don Guillett
SalesAid Software
donaldb@281.com
"cottage6" <cottage6@discussions.microsoft.com> wrote in message
news:8AACBF99-1203-4C5C-BD53-9F8C1E25236E@microsoft.com...
> 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?