COUNTIF

E

EK

I have the following alphanumeric data in a cell:

AA1234
BA1234
AA4567
AA2345
AD1234
---------
3 <- formula?
---------

I would like to know the formula to count the number of times data starting
with AA appear in a column. In this case, the result would be 3.

Thanks,
EK
 
R

RagDyeR

Another way:

=COUNTIF(A1:A5,"AA*")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I have the following alphanumeric data in a cell:

AA1234
BA1234
AA4567
AA2345
AD1234
---------
3 <- formula?
---------

I would like to know the formula to count the number of times data starting
with AA appear in a column. In this case, the result would be 3.

Thanks,
EK
 
Top