trouble shooting "COUNT"

  • Thread starter Thread starter epsaklas
  • Start date Start date
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?
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Help with counting formula 3
How do I count cells with non zero values? 1
counting over multiple pages?? 3
A macro that fishes for colored cells? 2
Count a column 3
Excel Count If Formula Question 1
Counting an entry in cells 3

Back
Top