counting only specific numbers in column
 

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.

=COUNTIF(A1:A50,2)


Regards,

Peo Sjoblom

"Alex C" wrote:

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.

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)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Alex C" <Alex wrote in message ...
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.