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

> 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

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)

--
Biff
Microsoft Excel MVP


"Nordic" <(E-Mail Removed)> wrote in message
news:28C5CCB8-F87B-491D-8357-(E-Mail Removed)...
> 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