=SUMPRODUCT((A1:A100<100)*(A1:A100<0))


"Bob Flanagan" wrote:

I need to count the number of cells in a range that are

less than 100 (some values may be negative)
Not empty (ie, exclude blanks)
Not zero

The last requirement is what is causing me the headache. A CountIF ignores
the blanks, but I can't figureout how to add a second condition for the not
zero requirement.

thanks

Bob