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:A10040))


In article ,
"bimseun" 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