Give this array-entered** formula a try...

=SUM(IF(LEN(E8:J15)=4,1))

** Commit this formula by pressing Ctrl+Shift+Enter, not just Enter.

Rick


"JCameron" wrote in message
...
I currently have a cell with the current definition:
=COUNTIF(E9:E200,"1000")
which yeilded the number of cells that have a value greater than 1000. Now
the data in this field has been changed to an alpha numeric string and I
would like to change the COUNTIF to count the number of cells where the
string length is equal to 4 characters. I have tried various things like:
COUNTIF(E9:E200,"LEN($)=4")
whith no luck. Any suggestions or solutions would be appreciated.
JCameron