Counts

[Guest]

How do I do a count in a column. I have a column with A, B, and P in it. I
want to count how many A's, B's, and P's.

Thanks,
Nordic

 

[Rick Rothstein \(MVP - VB\)]

How do I do a count in a column. I have a column with A, B,

and P in it. I want to count how many A's, B's, and P's.

Number of A's: =COUNTIF(A1:A100,"=A")

Number of B's: =COUNTIF(A1:A100,"=B")

Number of P's: =COUNTIF(A1:A100,"=P")

Rick

 

[T. Valko]

Try this:

Letters in the range A1:A100

C1 = A
C2 = B
C3 = P

Enter this formula in D1 and copy down to D3:

=COUNTIF(A$1:A$100,C1)