Counting occurence of a number

[kizza]

I have a list of about 200 numbers here ranging from 2-7. I want to count how many times each number appears so that I can put this into a graph, but I don't want to go through the whole thing counting each one individually.

Is there a quick way to count all of these?

Thanks.

[Dav]

2 choices slect the data and do a pivot table of the numbers as rows and count of the numbers of values

or put the number 1 in a215
2 in a 216 etc

then in b215 put countif($a$1:$a$200,a215)
and copy down

regards

Dav

[kizza]

thanks, i used the countif method and it worked well.

problem solved!