I need Counting Help

[Steven Anthony]

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!

[MrShorty]

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?

[Steven Anthony]

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!

[MrShorty]

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.

[Steven Anthony]

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.

[MrShorty]

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