Thanks for the response, but it didn't work. Result is 431. Looks like it
has "summed the product" instead of counting the cells.

I seem to recall someone writing about a double negative (--)somehow being
used in the SUMPRODUCT function to trick it into counting rather than
multiplying or summing.

Any other ideas?

"Vasant Nanavati" wrote:

COUNTIF doesn't play well with AND. Try:

=SUMPRODUCT((I4:I450=0)*(I4:I450<=10))

--

Vasant

"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