COUNTIF for range of numbers

[bimseun]

I hav got the following numbers:
A
45
54
12
32
55
78
65
45
I want to use the count how many of this is within the ranges
0-40
41-80
Please can someone advice on how to wtrite the function.
bimseun
11-20

[daddylonglegs]

If your numbers are all greater than or equal to zero and in range A1:A10

=COUNTIF(A1:A10,"<=40")

If the above formula is in B1 then for 41-80

=COUNTIF(A1:A10,"<=80")-B1

[JE McGimpsey]

One way:

0-40:

=COUNTIF(A:A,"<=40") - COUNTIF(A:A, "<0")

41-80:

=COUNTIF(A:A,"<=80") - COUNTIF(A:A, "<=40")

Alternatively:

0-40:

=SUMPRODUCT(--(A1:A100<=40),--(A1:A100>=0))

41-80:

=SUMPRODUCT(--(A1:A100<=80),--(A1:A100>40))


In article <[email protected]>,
"bimseun" <[email protected]> wrote:

> I hav got the following numbers:
> A
> 45
> 54
> 12
> 32
> 55
> 78
> 65
> 45
> I want to use the count how many of this is within the ranges
> 0-40
> 41-80
> Please can someone advice on how to wtrite the function.
> bimseun
> 11-20

[Ron Rosenfeld]

On Tue, 24 Jan 2006 06:13:02 -0800, "bimseun"
<[email protected]> wrote:

>I hav got the following numbers:
>A
>45
>54
>12
>32
>55
>78
>65
>45
>I want to use the count how many of this is within the ranges
>0-40
>41-80
>Please can someone advice on how to wtrite the function.
>bimseun
>11-20


=COUNTIF(rng,">=0") - COUNTIF(rng,">40")

However, depending on your application, you might be better served using the
FREQUENCY worksheet function.
--ron