2003 Excel

  • Thread starter Thread starter CC Bulinski
  • Start date Start date
C

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