View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default conditional count

Try COUNTIF:
=COUNTIF($A$1:$A$12,1)
=COUNTIF($A$1:$A$12,2)

Hope this helps,

Hutch

"TimW" wrote:

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