BRILLIANT!

This worked like a charm. I had to add a third term to the other nine
equations, but it worked. Thanks very much.



"KL" wrote:

Hi,

You can also try this:

=COUNTIF(I4:I450,"<=10")-COUNTIF(I4:I450,"<0")

Regards,
KL


"Marty" wrote in message
...
Hey all:

This seems like such a simple problem, but I've been staring at it for a
while and can't figure out what I'm doing wrong.

I have numbers ranging from 0 to 100 in cells I4 to I450 in a worksheet.
I
want to count the cells by increments of 10. In other words, I need 10
formulas showing:
-how many numbers are greater than zero and less than or equal to 10,
-how many are greater than 10 but less than or equal to 20,
-greater than 20 but less than or equal to 30,
and so forth.

Here is the formula I put into the cell to calculate the =0 and <= 10
range:

=COUNTIF(I4:I450,AND(I4:I450=0,I4:I450<=10))

This yields a zero. I know the answer should be 168.

Can somebody please tell me what's wrong with this formula?

Thanks,
MARTY