| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count cells that contain "Y" in columnA IF contains"X" in columnB | Excel Worksheet Functions | |||
| Count(if(A3:A200)="100000" if (B3:B200="Y") and (C3:C200=Z))) | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Hybrid Mode
