Adding up non numerical values
 

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!

Adding up non numerical values
 

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

On Sep 21, 9:10 am, Wooster wrote:
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!

Adding up non numerical values
 

Works perfectly. Thanks

"Pete_UK" wrote:

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

On Sep 21, 9:10 am, Wooster wrote:
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!

Adding up non numerical values
 

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

Pete

On Sep 22, 7:40 pm, Wooster wrote:
Works perfectly. Thanks



"Pete_UK" wrote:
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

On Sep 21, 9:10 am, Wooster wrote:
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!- Hide quoted text -

- Show quoted text -