Thread
:
Count cells with length not equal to 7
View Single Post
#
6
cottage6
Posts: n/a
Don, thanks a lot. I'm quite jealous of your logic!
"Don Guillett" wrote:
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?
Reply With Quote