On Thu, 7 Apr 2005 08:17:13 -0700, "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?


Here's one way:

Assume your data starts in B1. Enter =IF(LEN(B1)<7,0,1)
in C1 & copy it down. Then Sum column C.

I'm sure you'll get several answers, some probably cleaner than this
one, however, it may get you on your way for now.

Don S