countif not counting

[EvonS]

Sheet 1 has a column with a number of values selected from a drop down list (This 'Main' list is defined on a separate sheet 3)

Sheet 2 column A reflects the 'Main' list then column B uses a countif statement to count how many times the value in A appears. (See below)

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]a
[/TD]
[TD]b
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]=sheet 3 list
[/TD]
[TD]=countif a1 appears on sheet 1
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]=sheet 3 list
[/TD]
[TD]=countif a2 appears on sheet 1
[/TD]
[/TR]
</tbody>[/TABLE]






However the formulas are not counting all the times the value appears. I'm assuming I don't need to use trim because everything is based off of the same main list. Am I missing something?

 

[EvonS]

So I just used this conditional formatting formula <code>=LEN($A2)>LEN(TRIM($AA4882)) and it didn't highlight anything of note.</code>

 

[Aladin Akyurek]

The problem description is not clear. Try to post samples along with the desired output.