I need Counting Help
 

I'm trying to find out if it is possible to enter a series of numbers in
a single column, like

Column C
__________
1, 4, 5, 7, 9
1, 2, 5, 6, 7, 8, 9

and then construct a series of COUNTIF statements to tally up the numer
of times each acceptable value appears in the column.

So, for the example above, the results should be:

1 -- 2
2 -- 1
3 -- 0
4 -- 1
5 -- 2
6 -- 1
7 -- 2
8 -- 1
9 -- 2


Is this possible?

Thanks!


--
Steven Anthony


------------------------------------------------------------------------
Steven Anthony's Profile: http://www.excelforum.com/member.php...o&userid=24153
View this thread: http://www.excelforum.com/showthread...hreadid=377805

How about:
column D is 1,2,3,4,5,6,7,8,9
column E = countif($C$1:$C$11,d1) copied down through e9.

Is that what you are looking for?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=377805

MrShorty Wrote:
How about:
column D is 1,2,3,4,5,6,7,8,9
column E = countif($C$1:$C$11,d1) copied down through e9.

Is that what you are looking for?

I'm not sure--I'm an excel noob (at least to features like this).

In my example, the 2 rows under column C represent 2 rows in the
spreadsheet.

I'll give your suggestion a try (to the extent I understand how to do
it!) and see if it works.

Thanks!


--
Steven Anthony


------------------------------------------------------------------------
Steven Anthony's Profile: http://www.excelforum.com/member.php...o&userid=24153
View this thread: http://www.excelforum.com/showthread...hreadid=377805

When you say, " the 2 rows under column C represent 2 rows in the
spreadsheet.
", do you mean that the data are contained in two individual cells in
column C, or that column C is the first column, and each number is in
its own cell (across to column H)? If it's the latter, it's as simple
as moving the formulas around and changing the references. If it's the
former, then a simple Data - Text to columns to put the data into
columns, then change the references should work.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=377805

MrShorty Wrote:
When you say, " the 2 rows under column C represent 2 rows in the
spreadsheet.
", do you mean that the data are contained in two individual cells in
column C, or that column C is the first column, and each number is in
its own cell (across to column H)? If it's the latter, it's as simple
as moving the formulas around and changing the references. If it's the
former, then a simple Data - Text to columns to put the data into
columns, then change the references should work.

I was meaning "the latter." And your suggestion works like a charm--as
I'm sure you knew it would! Thanks! It really got me out of a jam.


--
Steven Anthony


------------------------------------------------------------------------
Steven Anthony's Profile: http://www.excelforum.com/member.php...o&userid=24153
View this thread: http://www.excelforum.com/showthread...hreadid=377805

Glad you got it figured out, and thanks for the feedback.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=377805