counting unique data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Got it!

many thanks, Biff!

T. Valko said:
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.
Click to expand...
 
Back
Top