counting unique data

[Guest]

Hi all,

i have a table like this

Names
A, B, C
A,B
B
C
B, C
A, C
C
A
A

I want to count all the “A†or “B†or “C†that come up. In this example A=5,
B=4, C=5.

Hope the question is clear and many thanks for your help.

Brie

 

[T. Valko]

Try it like this:

=COUNTIF(A2:A10,"*A*")

Or, put "A" in a cell then refer to that cell:

C1 = A

=COUNTIF(A2:A10,"*"&C1&"*")

Both formulas will only count a cell once if it might contain more than one
isnatance of "A". For example:

A2 = A, A, A, B, C

A2 will count as 1.

 

[Guest]

Got it!

many thanks, Biff!

Try it like this:

=COUNTIF(A2:A10,"*A*")

Or, put "A" in a cell then refer to that cell:

C1 = A

=COUNTIF(A2:A10,"*"&C1&"*")

Both formulas will only count a cell once if it might contain more than one
instance of "A". For example:

A2 = A, A, A, B, C

A2 will count as 1.

 

[T. Valko]

You're welcome. Thanks for the feedback!