conditional count

[TimW]

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

 

[Lars-Åke Aspelin]

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

Have a look at the worksheet function COUNTIF

Hope this helps / Lars-Åke

 

[Otto Moehrbach]

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

 

[Tom Hutchins]

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

Hope this helps,

Hutch

 

[Ashish Mathur]

Hi,

First of all, give a heading to the column. Create a pivot table - drag the
column to the row areas and drag it again to the data area. Right click on
any number, select field settings and select count

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com