Prev: Cell Referencing
Next: if-then statements or functions
From: TimW on 14 May 2010 15:03
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

From: Lars-�ke Aspelin on 14 May 2010 15:07
On Fri, 14 May 2010 12:03:01 -0700, TimW
<TimW(a)discussions.microsoft.com> 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
From: Otto Moehrbach on 14 May 2010 15:13
Something like this perhaps. This will give you a count of how many 1's
there are. Otto
=CountIf(A1:A20,1)

"TimW" <TimW(a)discussions.microsoft.com> wrote in message
news:CB3F7ABA-6631-4857-A53F-3C1EBDE78A8A(a)microsoft.com...
> 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
>
From: Tom Hutchins on 14 May 2010 15:16
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
>
From: Ashish Mathur on 14 May 2010 20:17
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" <TimW(a)discussions.microsoft.com> wrote in message
news:CB3F7ABA-6631-4857-A53F-3C1EBDE78A8A(a)microsoft.com...
> 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
>
 | 
Pages: 1
Prev: Cell Referencing
Next: if-then statements or functions