View Single Post
  #1   Report Post  
cottage6
 
Posts: n/a
Default Count cells with length not equal to 7

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?