Something like this perhaps. This will give you a count of how many 1's
there are. Otto
=CountIf(A1:A20,1)

"TimW" wrote in message
...
Any simple way to count how many 1s and how many 2s here?
2
1
2
2
2
1
2
1
1
2
1
1