counting only specific numbers in column

[Guest]

I have a column with ranges from A:1 thru A:50. I need to be able to count
how many times a specific number is used within all those ranges.. What
formula could I use to get this answer? Please see example below:

Column
2
2
2
2
3
3
2
6

Number of times 2 used - 5 times.

 

[Guest]

=COUNTIF(A1:A50,2)


Regards,

Peo Sjoblom

 

[David McRitchie]

Hi Alex,
Use COUNTIF see John Walkenbach's page:
Cell Counting Techniques
http://www.j-walk.com/ss/excel/tips/tip52.htm

=COUNTIF(Range("A:A",2)
=COUNTIF(Range("A1:A50",2)