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

On Fri, 14 May 2010 12:03:01 -0700, 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

Have a look at the worksheet function COUNTIF

Hope this helps / Lars-Åke

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

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

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

"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