G Guest Sep 20, 2007 #1 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. Thanks, Nordic
R Rick Rothstein \(MVP - VB\) Sep 20, 2007 #2 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. Click to expand... 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
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. Click to expand... 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 T. Valko Sep 20, 2007 #3 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)
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)
