trouble shooting "COUNT"

E

epsaklas

I have a 1000 line spread sheet where one column has an entry that is a code
as follows

X YY ZZ (Where each of the groups can be one or two characters

There are 15 or so different codes

I want to tally how many cells there are for each code, and used the COUNTF
function ....BUT the totals given by the COUNTF function are not right. It
is loosing a few of the cells. EG If I use the FIND ALL tool, it will show
65 "S H TN" entries, but COUNT shows only 59. If I sort on the column, I can
easily count the entries and this confirms that COUNT is loosing a few
entries. Any iddea why this happens?
 
E

epsaklas

Good point and thanks!! Yes there were some that had spaces and removing the
spaces solved some of the problem, but not all. Is there a way to highlight
all of the entries in a column that COUNT counts, so that I can see which
ones it is not counting? Any other idea?
 
Top