Countif Length

[snipescc]

Hi folks. I need to be able to tell if any cell in a column is 14 characters long. I think the way to do it is a combination of either an IF or a COUNTIF statement and a LEN, but I havn't been able to get the Syntax right. I would prefer not to add another column that looks at the length of each cell individually, but right now that's the only way I can figure out to do it. Any ideas? The column I want to check is BE:BE.

-Thanks

 

[Soggy]

Hopefully this will work.
=SUMPRODUCT(--(LEN(BE:BE)=14))

 

[snipescc]

It worked! Thank you!