formula for countIf with two conditions

[Bob Flanagan]

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

 

[Gary''s Student]

=COUNTIF(A1:A100,"<100")-COUNTIF(A1:A100,0)

 

[Teethless mama]

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