Hi!

Assume the list is in column A:

=SUMPRODUCT(--(A1:A20=0),--(A1:A20<=3))

Or, put the number ranges in two cells:

B1 = 0
C1 = 3

=SUMPRODUCT(--(A1:A20=B1),--(A1:A20<=C1))

Biff

-----Original Message-----
Hi,
I have a long column list of numbers that I need to count
instances of.
example: the instances of numbers =0 & <=3, =4 & <=7,
etc.
Thanks,
Soz


.