Thread
:
counting only specific numbers in column
View Single Post
#
3
David McRitchie
Posts: n/a
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.
Reply With Quote