counting unique data
 

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

counting unique data
 

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.

--
Biff
Microsoft Excel MVP


"Brie" wrote in message
...
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

counting unique data
 

Got it!

many thanks, Biff!

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"Brie" wrote in message
...
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

counting unique data
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Brie" wrote in message
...
Got it!

many thanks, Biff!

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"Brie" wrote in message
...
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