=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.