2003 Excel

This is my data:
CB 101
CC 201
CA 105
CC 123
CB 122
CA 109

Question: How do I sort the information given to tell me how many CA's I
have and so on??

Look in the help index for COUNTIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"CC Bulinski" CC wrote in message
...
This is my data:
CB 101
CC 201
CA 105
CC 123
CB 122
CA 109

Question: How do I sort the information given to tell me how many CA's I
have and so on??

Hi,

Is this data in 1 or 2 columns?

Assuming 2: Then put your cursor in the first column and click the
Ascending Sort, then choose Data, Subtotal, set At each change in to the
first column, set Use function to Count, under Add subtotal to check the
first column, click OK

Alternatively
=COUNTIF(A1:A100,"CA")

or

=COUNTIF(A1:A100,D1) where D1 contains CA

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"CC Bulinski" wrote:

This is my data:
CB 101
CC 201
CA 105
CC 123
CB 122
CA 109

Question: How do I sort the information given to tell me how many CA's I
have and so on??

I read your question slightly differently: you want to sum all the numbers
in column B where the corresponding A value is CA.
=SUMIF(A1:A100,"CA",B1:B100)
best wishes
--
Bernard Liengme
MVP Excel
http://people.stfx.ca/bliengme

"CC Bulinski" CC wrote in message
...
This is my data:
CB 101
CC 201
CA 105
CC 123
CB 122
CA 109

Question: How do I sort the information given to tell me how many CA's I
have and so on??