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.

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

"Sav_C" wrote in message
...
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.

Sav-C:

Try this:

Assuming your data is in the range A1:C15.

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


Matt


--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310
View this thread: http://www.excelforum.com/showthread...hreadid=568823

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

"Sav_C" wrote in message
...
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.

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" wrote in message
...
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

"Sav_C" wrote in message
...
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.

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

"Biff" wrote in message
...
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

"Sav_C" wrote in message
...
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.

Thanks Biff, Flintstone and Paul B.

"Paul B" wrote:

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" wrote in message
...
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

"Sav_C" wrote in message
...
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.