COUNTIF
 

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

COUNTIF
 

Hi

Try
=SUMPRODUCT(--(LEFT(A1:A20,2)="AA"))

--
Regards

Roger Govier


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

COUNTIF
 

Another way:

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

HTH,

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


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

COUNTIF
 

Much better, Rick!

--
Regards

Roger Govier


"RagDyeR" wrote in message
...
Another way:

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

HTH,

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


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

COUNTIF
 

It would make Harlan happy, with less function calls!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Roger Govier" wrote in message
...
Much better, Rick!

--
Regards

Roger Govier


"RagDyeR" wrote in message
...
Another way:

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

HTH,

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


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