On Sun, 22 May 2005 14:30:03 -0700, "Marty"
wrote:

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

You could also use the FREQUENCY worksheet function.

Select 10 cells.
Click in the formula bar.
Enter the following formula into the bar.

=FREQUENCY($I$4:$I$450,{10,20,30,40,50,60,70,80,90 ,100})

Then, instead of hitting <enter, hold down <ctrl<shift while hitting
<enter.

This will be entered as an array formula and you will have the output you are
looking for.


--ron