Adding the number of table entries by type

[Guest]

Hi,

I have a table which has the letters A-F appearing a number of times in the
fields

e.g.
A A A A B C D E F
C D A B E F A A B
.....

I want to add the number of times the letter A or B etc. appears and display
the answer in another blank field outside the table above.

What I would like to do is have a second table that shows the answers like so:

A 7
B 4
C 3
D 2
E 4
F 6

How do you get the fields to add up the contents of letters?

Help much appreciated.

Thanks.

 

[Biff]

Hi!

Assume your table is in the range A1:I2

Enter this formula in some cell, say, A5:

=CHAR(ROW(A65))

Enter this formula in B5:

=COUNTIF(A$1:I$2,A5)

Select both A5 and B5 then copy down to row 10.

Biff

 

[Flintstone]

Sav-C:

Try this:

Assuming your data is in the range A1:C15.

="A "&COUNTIF(A1:C15,"=A")


Matt

 

[Paul B]

Sav_C,
here is one way, change range to your range

="A " & COUNTIF(A1:I20"A")
="B "& COUNTIF(A1:I20"B")
.............
.............
..............

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Paul B]

should be,

="A " & COUNTIF(A1:I20,"A")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Paul B]

I like Biff's, you want have to change the letters, just to add to it you
could use one column like this and copy down

=CHAR(ROW(A65))&" "&COUNTIF(A$1:I$2,CHAR(ROW(A65)))

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Thanks Biff, Flintstone and Paul B.

should be,

="A " & COUNTIF(A1:I20,"A")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003