Adding up non numerical values

[Guest]

In one column I will have a variety of letters. (A, B, C etc) In another
cell I want to have the sum of all the A's in that column. In a different
cell I want to have the number of B's in the column - and so on. How do I do
this?
Thanks in advance!

 

[Pete_UK]

Try this:

=COUNTIF(A1:A100,"A")
=COUNTIF(A1:A100,"B")

etc., where I have assumed your data is in A1:A100.

Hope this helps.

Pete

 

[Guest]

Works perfectly. Thanks

Try this:

=COUNTIF(A1:A100,"A")
=COUNTIF(A1:A100,"B")

etc., where I have assumed your data is in A1:A100.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome - thanks for taking the trouble to feed back.

Pete