I have a column of numbers like that below. I want to coun how many times
each value appears in the column. How do I do that (other than print it out
and count by hand)?

31
30
27
24
23
23
22
20
19
18
18
17
16
16
15
14
13
13
12
12
11
11
11
10
9
9
9
9
8
8
7
7
7
7
6
6
6
6
5
5
4
4
4
4
4
4
4
3
3
3
3
3
3
3
3
2
2
2
2
2
2
2
2
2
2
1
1
1
1
1
1
1

Use the countif function. Here's an example:

=COUNTIF(A1:A12,"31")

where A1:A12 is the entire range of cells you want to use, and 31 is the
value you want to count. In the example, this will count all values of 31
within the range of A1 to A12.

Hope this helps,
Chad


"allen" wrote:

> I have a column of numbers like that below. I want to coun how many times
> each value appears in the column. How do I do that (other than print it out
> and count by hand)?
>
> 31
> 30
> 27
> 24
> 23
> 23
> 22
> 20
> 19
> 18
> 18
> 17
> 16
> 16
> 15
> 14
> 13
> 13
> 12
> 12
> 11
> 11
> 11
> 10
> 9
> 9
> 9
> 9
> 8
> 8
> 7
> 7
> 7
> 7
> 6
> 6
> 6
> 6
> 5
> 5
> 4
> 4
> 4
> 4
> 4
> 4
> 4
> 3
> 3
> 3
> 3
> 3
> 3
> 3
> 3
> 2
> 2
> 2
> 2
> 2
> 2
> 2
> 2
> 2
> 2
> 1
> 1
> 1
> 1
> 1
> 1
> 1
>
>

=COUNTIF(A:A,A1) and copy down.
--
David Biddulph

"allen" <(E-Mail Removed)> wrote in message
news:59944E4E-8FA3-4177-8686-(E-Mail Removed)...
>I have a column of numbers like that below. I want to coun how many times
> each value appears in the column. How do I do that (other than print it
> out
> and count by hand)?
>
> 31
> 30
> 27
> 24
> 23
> 23
> 22
> 20
> 19
> 18
> 18
> 17
> 16
> 16
> 15
> 14
> 13
> 13
> 12
> 12
> 11
> 11
> 11
> 10
> 9
> 9
> 9
> 9
> 8
> 8
> 7
> 7
> 7
> 7
> 6
> 6
> 6
> 6
> 5
> 5
> 4
> 4
> 4
> 4
> 4
> 4
> 4
> 3
> 3
> 3
> 3
> 3
> 3
> 3
> 3
> 2
> 2
> 2
> 2
> 2
> 2
> 2
> 2
> 2
> 2
> 1
> 1
> 1
> 1
> 1
> 1
> 1
>
>