On Tue, 24 Jan 2006 06:13:02 -0800, "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


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

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