Thread
:
conditional count
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Tom Hutchins
external usenet poster
Posts: 1,069
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
Reply With Quote
Tom Hutchins
View Public Profile
Find all posts by Tom Hutchins