Adding the number of table entries by type
 

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.

Adding the number of table entries by type
 

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.

Adding the number of table entries by type
 

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

Adding the number of table entries by type
 

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.

Adding the number of table entries by type
 

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.

Adding the number of table entries by type
 

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.

Adding the number of table entries by type
 

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.