trouble shooting "COUNT"
 

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?

trouble shooting "COUNT"
 

are there maybe spaces at the end of the text?
EG "S H TN "


"epsaklas" wrote:

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?

trouble shooting "COUNT"
 

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?

"dlw" wrote:

are there maybe spaces at the end of the text?
EG "S H TN "


"epsaklas" wrote:

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?