I need Counting Help

S

Steven Anthony

I'm trying to find out if it is possible to enter a series of numbers i
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 nume
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
 
M

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
 
S

Steven Anthony

MrShorty said:
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?
Click to expand...

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 th
spreadsheet.

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

Thanks
 
M

MrShorty

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

Steven Anthony

MrShorty said:
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.
Click to expand...

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.
 
Top