2003 Excel

[CC Bulinski]

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??

 

[Don Guillett]

Look in the help index for COUNTIF

 

[Bernard Liengme]

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